-
automated back up
Hi expert. I have installed the SQL server management studio 2013 in the server machine. I have set up the back up plans and schedules from the backup maintenance wizard of the maintenance plans. But nothing was back up. I have done the same thing for another testing machine, but it is working fine. Please advise! Thank…
-
facing error when connecting to live server databse instance
hi experts I am facing error while connecting to the live database server instance "The following sql error was unexpected. Alter table drop column failed because column source document type does not exist in table Test$Transfer line." what to do now share your feedback thanks in advance sir. :roll:
-
Incorrect syntax near 't'. in SQL SERVER 2012
Hi i am Try to restore a DB that time i will get Error Message Like this : TITLE: Microsoft.SqlServer.ConnectionInfo An exception occurred while executing a Transact-SQL statement or batch. ADDITIONAL INFORMATION: Incorrect syntax near 't'.Unclosed quotation mark after the character string ''. (Microsoft SQL Server, Error:…
-
SQL permissions to create NAV windows logins
Hi all, I want to delegate creating windows logins in Dynamics NAV (currently 2009 R2 Classic) to several key users in our company but I don't want to assign the SQL database role db_owner or server role sysadmin to the users. I've made several tests with an user account and I got it worked with the database role…
-
The request failed or the service did not respond in timely
Hi Experts I am facing error while starting sql server agent under NavDemo instance what to do? "The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details".
-
SQL ADO Query
Hi, I am writing a small functionality into Navision which will transfer data from 1 db to another db using ado user will be able to configure himself, which tables and filters etc. like sales order for this department should be copied into another db. it will generate sql script and execute. It works fine but....getting…
-
NAV Tab definition in SQL
Hi, simple question :-) Is it a possible find NAV Table definition direct from SQL. Concretely I mean Fields Name, Fields ID (maybe Type, Description, Relation.. or other) I have just written simple app in C# and I'm reading this data from an exported table (txt file). But this is not dynamical at changes in NAV. :/ Thanks…
-
Job to check Transaction Log Size
Hi guys, can i configure a job on sql just to check the amount of the log file? I want to receive an email if a certain amount it's reached. Thanks for your attention.
-
How i make ERD Diagram for payroll salary for employees
Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for this…
-
Install SQL Server 2012 Web edition on Azure (2VM script)
Hi! Since I'm a newbie on installing stuff on Azure I would like to share my experiences. I was going to do a installation with the 2VM script (http://msdn.microsoft.com/en-us/library/dn168972(v=nav.70).aspx) but ended up with some problems with the SQL Server 2012 Web edition image. If you look at the SQL images you can…
-
NAV 2013 Blanket Sales Order Question
Is there a field in the blanket sales order lines table that reflects the "outstanding blanket order" quantity? There might be some open unposted sales order along with some posted sales invoices but which field give a net of the remaining "outstanding qty" on the blanket sales order? Please advise. Thanks, NAV2013
-
Server Change
What's the best way guys ?? I have a new virtual server Win 2012 Datacenter on 64bit with Intel Xeon E5-2665 @ 2.40GHz and 14.2 GB Ram. All setup with SQl Server 2008 R2. Database created with restore of previous backup and tested - all working well. - Dynamics Nav 2009 R2 I'm looking foreward to going live with this, but…
-
free SQL Server 2014 eBook from Microsoft Press
http://www.microsoftvirtualacademy.com/ebooks Light reading, but a good first overview - for free.
-
Adding table and putting that as field on page
All - I need help with a small task. Can someone help me with instructions on how to create a table and add that as a field on the sales quote page? NAV 2009 R2 Version Table is called "Quoted by" Simple table two columns 1. Code - Max 20 characters, only alpha 2. Description - Max 60 characters, only alpha Add this table…
-
NAV vs SQL Permission
Hi, Just wondering, does it work like this or how can I achieve this if a nav users does not have permission to read a particular table he should not be able to read that sql table from outside as well We have excel connectivity which read sql directly and users can read all the tables. even they do not have permission…
-
Manually Close Sales Order Short - NAV 2009 R2
We have a Sales Order that was originally made out for 200’. We shipped 100’ so it left 100’ on backorder. We changed the order qty to 100’ because we want to consider this line complete. How can I manually close this sales order as no more shipping or invoicing will be done against that line? NAV 2009 R2 Thanks, NAV2013
-
SQL Seerver 2014
SQL Server 2014 released to manufacturers, will be generally available April 1. Is there any official word on NAV versions compatibility. Has anyone been testing the beta version with NAV?
-
SQL Query to fetch the data
Dear Sir, How to get (using sql query) all the data from a single table from all the companies in a single NAV Database ? We can use 1. Join 2.Cursor 3. CTE Is there any thing apart from that ? Kindly reply.
-
C/Side to SQL Migration - specifying the corrected dates
Hi, I'm converting a database from C/Side to SQL. The FieldCheck codeunit displays a form with the "Incorrect Values" table at the end, asking you if you wish to implement the recommended changes. This database has quite a few date errors (almost 700), and NAV doesn't do a great job in suggesting the "correct" date - it…
-
Clever way to backup the objects from multiple databases?
We have many customer NAV databases in versions from NAV4 to 2013R2 in our SQL database for development purposes. Currently we daily take a full backup of all databases, because that is the only place we got the objects. However; the total size of the databases are soon causing problems for our backup device. We would…
-
Log File how i prevent form growing
Helo guyi have SQL 2008 R2. My database is about 25GB, Recovery Model is Full, and the Log File is set to a Initial Size of 1GB and the Autogrowth By 1000MB to a restricted growth 2097152MB. In a couple of hours the Log (as the Initial Size) is 4GB. Can you tell me why? How can i prevent this quick growth? Thanks for your…
-
How to rename SQL Server 2013 Instance Name
Hi All, Can anyone tell me how to rename SQL Server 2012 instance name? I'm using SQL Server 2012 version 11.0.2100.60. I would like to rename it to 'VOSTROI5'. Please guide. Thanks in advance Best regards, Philip
-
Find inactive Windows Logins
Dear all, Is there any way to know the list of all inactive Windows users in the AD thru the SQL query ? Note : Users are disabled in OS Level but they have access in SQL Level.
-
Microsoft SQL Server 2012 Compatibility with NAV = YES
Is Microsoft SQL Server 2012 Compatible with NAV 2009R2 (or above) ? Thanks. Confirmed by MS :thumbsup:
-
SQL Security with NAV 2013
Hi I was searching for information about this topic, with no success... As far as I know, NAV 2013 does not use xp_ndo.dll and the $ndo$shadow application role anymore. Are there information and/or web links available on how security is done on sql server side in NAV 2013? Thx in advance Thomas
-
Error SQL Insert into table with SumIndexFields
Hello, I have made a simple SQL query to instert information from table [A] to table , this two tables are Navision tables. This is the query: INSERT INTO SELECT * FROM [A] I execute the query and it works well, the problem is if I put in a table in Navision key any value in field SUMINDEXFIELD, if I add information in…
-
Growing Log File Frustrations
Hi all Can someone put their finger on why my log file continues to grow event though I have a database backup and transaction log backup running nightly, the backup is then restored to a fresh training database. The Recovery Model is Full (as far as I have been informed this cannot be changed to simple) as the database is…
-
Copying data between NAV tables using SQL
Hi guys, I want to copy data between two copies of the same object (create replica of the table) using SQL statement. Something like: insert into [Test Table 02] select * from [Test Table 01] It gives an error: As suggested by the error message I can change this code intoinsert into [Test Table 02] (field1,…
-
Another user has modified the record
Hi ! We have an Update trigger to catch up records of few fields from Sales line table to another table being with another DB. But that leads to error in Navision postings, like the below, Another user has modified the record for this Sales line after you retreived it from the database. Enter your changes again in the…
-
Log File
Hi expert, I tried to shrink the log file using the following command: use [bagstore] go dbcc shrinkfile([bagstore_Log.ldf], 10) But I had an error as below: Server: Msg 8985, Level 16, State 1, Line 2 Could not locate file 'bagstore_Log.ldf' in sysfiles. DBCC execution completed. bagstore_Log.ldf is the only one for the…