Tagged: SQL

How to transfer user logins between to SQL Servers

Hi !

If you are installing a new SQL Server and would like to transfer the logins from an old SQL Server, without doing a SQL restore, then you can do it with a script.

Take a look on this article How to transfer logins and passwords between instances of SQL Server; here Microsoft describes how to do it. Read more »

Writing an automation for Navision in C#

code-dynamics

Writing a automation for Navision is pretty simple, when you first know how to do it :-)

First of all, I assume that you already know about C#.

So here are the basic steps for creating an automation:

Read more »

Trace Flag 4616

When using Navision (Dynamics NAV 5.0 or higher) with SQL 2005 (express or full) – you will receive a trace flag error, when trying to create a new database, unless you already has changed your SQL Server configuration.

So what to do when receiving this error? That’s simple – add the trace flag ;-)
Read more »

Sorting of a Code field in SQL vs. Native

Did you know that a Code field is sorted different depending of you are using Native or SQL?

SQL will sort the Code field as a Varchar – which means it will sort the Code field as text!

In the following sorting example you can see the sorting Native vs. SQL
Read more »

Using SQL Views in Navision

code-dynamics

Did you know that it is possible to use views in Navision?

If you often are collecting/viewing data from several tables it can be usefull to use a SQL View. Created SQL Views can then afterwards be used from Navision.

First you have to create the SQL View. This is can be done in 2 ways on the SQL Server.

One way is to use the Microsoft SQL Server Management. Here you right click on View select New where you afterwards can select tables, joins, fields etc.

Read more »

Importing Image from a non Navision table to a Navision blob field

code-dynamics

In SQL it is possible to define tables with a column, which is of type image. This field type is not known by Navision or by ADO and can thereby not be extracted like other fields.

There exists 2 ways to get this fields value.

1) One way is to stream the image to a file and then afterwards import it into the blob.

Read more »