SQL General

Just posted details of this on our team blog https://blogs.msdn.microsoft.com/nav/2018/01/11/sql-server-2017-and-dynamics-nav/ Best, Kennie

I'm using SSMS client. In my client everything will connect fine, but if i go to another computer and try to connect to the server, it could't connect. What should I do?

Hi Guys Do you know if business Central 365 is supported when it will be installed on a Linux/Ubuntu vm with sql 2017? Any experience with it?

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,…

I have an MDF file that seems to be corrupted. I can’t open it in SQL Server, and I don’t want to lose my data. Is there an easy way or a tool to repair the MDF file and recover all the data safely? Any suggestions or steps will be really helpful.

Hello, For our customers system we have two different servers where the specific services are running. Specifically, it deals with the problem that a service on server A, which has activated the TaskScheduler and is only responsible for the job queue, has an error in combination with a service on server B, which is only…

Please, help me. I need information on the sales invoice regarding quantity, price, etc., but in the report, I want to see the price at which the item was purchased, the currency used, and the purchase date. How can I track this or combine sales invoice and purchase invoice?

Hello, I had to create an additional instance of SQL SERVER. I can set that instance in development by defining Database Server to SRVNAV\MSSQLSERVER01 and Server Instance as link/dynamicsnav110. And it seems to set fine in dev environment. BUT when I try to open some page, i get data from old instance, and I not sure how…

SQL Server configured to use collation Latin1_General_CS_AS. NAV use Code(20) type column in primary key and SQL and NAV produces following wrong order: HUTNY-MATE-POLYESTER HUTNY-MATERIAL-PZN HUTNY-MATE-W.15,WPA where HUTNY-MATE-W.15,WPA should be ordered before HUTNY-MATERIAL-PZN. What is the reason or what is wrong?

Sorry, forgive my ignorance. I could get this right in my mind. Customer will have 50 NAV2018 users in an On-Prem environment. One SQL2019 server on Windows 2022 server. Another separate Windows server 2022 for Navision Application Server. Only NAV accesses the SQL using a single windows domain user name. May be one or two…

We are using NAV 2016 -(version 9.00.46621). I get an error when I compile the Service Header table object. This error occurs only for this table. It started happening recently. I can compile all other objects. I get the following error : An updated definition for table Service Header cannot be applied in SQL because the…

Hi, A user is on NAV2017 and Microsoft SQL Server 2016 Enterprise Edition. The error log for the NAV Service tier contains various rows with the error message "The server failed to resume the transaction". Does anyone have experience with this error and experience regarding how to solve it? Thanks in advance for any help

Hello everybody! In our organization we have an "on premise - Dynamics 365 Business Central" server that runs our main business database. It runs version 14, that is, Dynamics 365 Business Central Spring Release v14.00 I believe is also called Wave 1 2019. We now use the "web" client (after many, many years of using the…

Hi guys, When I try to rename Item WebClient crashes. The error that I found in event viewer looks like this. When I try to debug Base app I get that client crashes when GlobalTrigger GetGlobalTableTriggerMask parameter TableID=7326. Any help would be appreciated. Message: Specified method is not supported. StackTrace: at…

for an example, I want to extract store procedure for INSERT item from SQL Profiler so from store procedure i will get idea how much table hit during INSERT.

Hi, We converted our sql server database to 14.0.3391.2, then we did a NAV upgrade from NAV 2016 to BC14/NAV 2018. Now, our database size is increasing much faster than it did before. In addition, our differential backup is increasing at 5 or 10 times the rate it did before. Has anyone noted this condition? Does BC14 tend…

Hi What would be best sql replication methods for Dynamics NAV 2018 database which the partner still uploads changes (objects including tables). The DB is around 200GB and subscriber will also be in the same premises (different building) I see snapshop, transactional etc. Not sure which one will work in this case?

Hi, Recently one of our customers is having deadlock issues on their NAV 2018 environment. In one specific case we captured the deadlock trace using SQL Profiler. The victim process was trying to get an exclusive lock for performing a DELETE. The other process had this SQL command: SELECT TOP 1 NULL FROM "some…

Hi, I have executed the following SQL query on a NAV Database for two different companies and I surprise to see the column sequence. It differs from one another. SELECT * FROM CompanyName$TableName; What is the reason behind it? How do I fix that ? Thanks, navuser1

Hi, We're using NAV 2018 and we have multiple companies on our database. We want to delete a certain company including all data on it, we've already deleted it on NAV RTC but when we look on the SQL database all tables and views are still there. Is there a way to delete a company and all of its records in a simple way?.…

I am going to upgrade BC140 CU 11 to CU 20 (In order to apply some platform bugs fixed by microsoft) Error occured when open Db in step of converting Db to new CU version "ALTER DATABASE ... SET SINGLE_USER is not supported" Database is hosted in Azure SQL Managed Instance (aka SQL MI) After a few research, I realized that…

A client gets this error after having upgraded an old Windows 2008R2 server to Windows 2012: The following ODBC error occurred: Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Status-ID: IM002 We have found several threads suggesting to re-install the Native Client for…

I need to copy a set of tables from one DB to another DB, the tables structure is the same but the problem is when using Import/Export wizard I'm getting error that for table. Timestamp is used as column for all the set of tables which we cannot use for copy, so some one please suggest how to copy the data from db to db.…

Hi folks, I am facing this error for days and I still can't find a solution. Here is the error: I have multiple services that connect on the same sql server instance and obviously on the same database. Our IT Managers did this for balance computing, or at least this is what they said. This is part of the stack trace,…

i have focus accounting program , and i register dll file for active barcode and working in server , but i register dll file in cilent pc but not working . This massage error : activex component can't create object Please help me

Hi Everyone! I'm trying to insert to a secondary table whenever there is an insert another table( Member Point Entry). The issue is when I manually do an insert by T-SQL then its getting inserted and the trigger is fired properly. But at our site we have data director (product from LS Retail for replication), and when…

One of the benefits of Ms Dynamics nav is its open physical data model. It allows us to generate external OLTP reporting, upload data for OLAP repositories with simple SQL queries without additional data extraction and decryption operations. Everything would be fine until we come across fields with the Blob type (in SQL,…

Hi Can someone tell what this error means and how I can solve it. Thanks.

In NAVISION 2009 R2, it seems like NAV always request every attributes of the records (by sending a "SELECT * FROM" SQL request), even if I only use a single attribute of the records (e.g. : via code on a report or via the columns of a form). Example of an actuel SQL request send by NAV : SELECT * FROM…

Hi all This seems unbelievably basic but I just can't seem to figure it. I want to update a heap of vendor payment term codes from another table which I read in from Excel. My new table consists of just two columns: the Vendor No. and what I want their payment terms to be. So, for example, I might have an entry for Vendor…