NAV 4.00 SP2 - not suitable for MS SQL 2005

Because there are some problems with Database - Alter when SP2 is used with MS SQL 2005, I recommand to not use SP2 for 4.00 in live business when you are using MS SQL 2005. Microsoft is solving the problem, I hope, that there will be some update available in short time.
Published Mon, Apr 10 2006 11:41 by kine
Filed under:

Comments

# re: NAV 4.00 SP2 - not suitable for MS SQL 2005

Kine,

Has the issue of SP2 on SQL 2005 been resolved yet?

Martin

Tuesday, November 28, 2006 1:13 PM by Martin Kolar

# re: NAV 4.00 SP2 - not suitable for MS SQL 2005

Yes, as you can see in the article http://msmvps.com/blogs/kine/archive/2006/05/17/100361.aspx the main problem was solved in Rollup 1 for SP2, and of course by SP3. But there are still some issues with Max Size of DB files. But this can be solved by entering correct values. Since Rollup 1 for SP2, you can use the 4.00 with MS SQL 2005 without problems.

Wednesday, November 29, 2006 12:34 AM by kine