SQL – Page 2 – TechBlog

Automations

ADO in Navision

20 February 2008 iby 5

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 […]

ADO.NET

19 February 2008 iby 0

For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server. The common way to access a database is to do the following: […]

What is ADO and can it be used in Navision?

17 February 2008 iby 0

ADO (ActiveX Data Objects) is a Microsoft technology and is a interface to access data in a database. So what can ADO be used for in Navision?

DBREINDEX and INDEXDEFRAG example

4 April 2006 iby 0

If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.

Some usefull SQL Commands

2 April 2006 iby 0

If you are a SQL Server administrator or just working with it, these commands would be use full for you. ALTER INDEX Modifies an existing table or view index (relational or XML) by disabling, rebuilding, […]