Development
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. […]
SQL
Applications
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 […]
Development
Using SQL Views in Navision
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 […]
Automations
Importing Image from a non Navision table to a Navision blob field
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 […]
Automations
ADORecordSet
Hi ! This is a detailed description for the used ADORecordSet command mentioned in the articles Stored Procedures and Navision and ADO in Navision. ADORecordSet The ADO RecordSet is defined by the automation ‘Microsoft ActiveX […]
Automations
ADOCommand
This is a detailed description for the used ADOCommand command in the articles Stored Procedures and Navision and ADO in Navision. ADOCommand The ADO Command is defined by the automation ‘Microsoft ActiveX Data Objects 2.8 […]
Automations
ADOConnection
Hi ! I have been asked to describe the different ADO commands parameters more explicit. So here are a detailed description for the used ADOconnection command in the articles Stored Procedures and Navision and ADO […]
Automations
Stored Procedures and Navision
If you are executing a specific SQL query very often, it would be usefully to have it as Stored Procedure on the SQL Server. Stored Procedures is a collection of SQL statements. There are 2 […]
Automations
ADO in Navision
With ADO you can execute SQL Scripts and Stored Procedures from Navision. To use ADO in Navision, you have to use the automation “Microsoft ActiveX Data Objects 2.8 Library” Lets take a closer on how […]
.NET