Accelerating into the Future with Wisdom about Technology! Ingrid Byllemos
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 the rest of this entry »
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 the rest of this entry »
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 the rest of this entry »
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.
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.
Hi !
This is a detailed description for the used ADORecordSet command mentioned in the articles Stored Procedures and Navision and ADO in Navision.
The ADO RecordSet is defined by the automation ‘Microsoft ActiveX Data Objects Recordset 2.8 Library’.Recordset or by ‘Microsoft ActiveX Data Objects 2.8 Library’.Recordset
It is used to hold a set of records from a from a database table or a defined query. The Recordset object contains rows and columns (fields).
Read the rest of this entry »