Browse by Tags

• SQL

Basic SQL - Restoring a SQL Server backup
08 November 08 08:37 AM | Lohndorf | 1 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". You can back up your Microsoft Dynamics NAV database either from a NAV client or from SQL Server Management Studio. To restore a backup made from SQL Server, follow Read More...

Filed under: SQL, Basic SQL

Basic SQL - Creating users in NAV on SQL
08 November 08 08:34 AM | Lohndorf | 1 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server first. If you try to create a user which does not Read More...

Filed under: SQL, Basic SQL

Basic SQL - How to attach a database to SQL Server
08 November 08 08:27 AM | Lohndorf | 2 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". If you receive a SQL Server database file (.MDF), then you must attach this to your SQL Server before you can access it. This is how to do that: 1) Copy the Database Read More...

Filed under: SQL, Basic SQL

Basic SQL - How to create a new NAV database for restoring a NAV backup
05 November 08 02:52 PM | Lohndorf | 3 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps are done from a NAV client: 1) Start a NAV client Read More...

Filed under: SQL, Basic SQL

Basic SQL - Enable trace flag 4616 on SQL Server
05 November 08 02:46 PM | Lohndorf | 1 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to Read More...

Filed under: SQL, Basic SQL

Basic SQL - Creating Extended Stored Procedure / xp_ndo.dll
05 November 08 02:43 PM | Lohndorf | 3 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures Read More...

Filed under: SQL, Basic SQL

Basic SQL - Installing SQL Server 2005 / 2008
05 November 08 02:34 PM | Lohndorf | 4 Comments   

This post is part of " Overview of NAV-specific SQL features for application consultants ". It describes the simplest way to get SQL Server installed in a test environment. It only mentions the changes to the default installation options that you need Read More...

Filed under: SQL, Basic SQL

Basic SQL - Overview of NAV specific SQL features for application consultants
05 November 08 08:52 AM | Lohndorf | 23 Comments   

As the title says, this post is not really for NAV developers, but for application consultants who don't use SQL Server every day but still need to know enough about SQL Server to at least get a Microsoft Dynamics NAV database to run on it. The challenge Read More...

Filed under: SQL, Basic SQL