Navision and SQL 2005

HalMdy

Has someone already tested to install Navision on a SQL 2005 server ?
How does it look like ? Do you have access to the "Partial recovery" part of SQL ? Wich version of Navision do you use ?

fcassoli

I tried biefly with Navision 4.0, and it seems to work (I posted a sales order and a purchase order and had no errors).
I tried no "advanced" operations.

Federico

kine

SQL 2005 is supported since 4.00SP1 (4.01). I did not tryed it without the SP1 yet...

Frodio

I got some problems regarding data types.

The session is of integer in navision, but BigInt in sql database.
Not sure if this is fixed in SP.1 or if there are any ways to work around this on issue in 4.0?

Anybody got any suggestions so please let "us" know?

kine

I have this problem too...

Frodio

Works on 4.0 SP1 \:D/

kine

And it is why SQL 2005 is supported only for SP1... ;-)