Dynamics NAV and SQL2008

Just recently SQL 2008 got status RTM and is ready to use in production systems.

At SQL Perform we are always very careful with new releases and eager to test them for performance, reliability and management capabilities.

What better way to start than with your own database. So we installed SQL 2008 on Windows 2008 on our VMWare server.

After the normal procedure of setting traceflag 4616 and attaching the stored procedures it was possible to create a new database.

The database got version number 100 which is the internal version number for 2008.

So as from today we'll start using 2008 and explore the capabilities.

Officialy it is not yet supported I guess.

We are using the CTP3 build for NAV 2009 and combine both the classic and the Role Tailored client.

I tested also with Navision 4.0 SP3 update 8 and this works as well.

One of the first things I noticed was autocomplete and syntax hints. Wow! I am in heaven. Big Smile

Results and new interesting features will be posted as soon as possible. We also moved our analysis databases to the SQL2008 which are regular SQL databases we use for measuring performance at our customers.

More information on www.sqlperform.nl

Comment List