SQL – Page 18 – Pardaan.com

Using a SQL view in a NAV 2009 RDLC Report

Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. Bron…

18 March 2012

Dynamics NAV & BC Tips & tricks

Copy Navision Data Between Databases using SQL Server

Microsoft SQL Server has an import and export wizard that assists you in copying Navision data from one database to another. This import and export wizard is available in any version of SQL Server, and it lets you copy tables, data, functions and other database objects.…

6 March 2012

Dynamics NAV & BC Tips & tricks

SQL-Util to unlock NAV-db

After you have restored a NAV SQL database to your PC, you may need to unlock the database. Here is my sql-script: SQL-tool to unlock NAV-DB (SQL-server). This script creates a new user “TEMPUSER’ in SQL Server and the NAV database so you can log on…

1 February 2012

Dynamics NAV & BC Tips & tricks

Migrate from Native to SQL Server : dates before 1753/01/01

Now that the native database is destined to disappear, it is more than ever time to migrate your database to SQL Server. Bron : Kriki’s Dynamics NAV blog Lees meer...

31 January 2012

Dynamics NAV & BC Tips & tricks

Configuring a SQL Server database for Microsoft Dynamics NAV & Writing less expensive C/AL code for customizations

It is imperative that while configuring Microsoft Dynamics NAV, the hardware and software recommendations from Microsoft are taken into consideration. From using the latest version of Microsoft Windows, Microsoft SQL Server, or other Microsoft stack products that are intended to be used with Dynamics NAV or…

18 January 2012

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV: Backing up and restoring with SQL Server

If we are using the Dynamics NAV SQL Server option, the recovery plan for our backups will depend a lot on the recovery model we have selected for the database. Bron : Allcomputers.us Lees meer...

11 January 2012

Visual C# / ASP.net

Creating Connections to SQL Server

When connecting to SQL Server use the Microsoft OLE DB Provider for SQL Server. Bron : MSDN Lees meer...

6 January 2012