Home Forums Older Versions of SQL (v6.5, v6.0, v4.2) Older Versions of SQL (v6.5, v6.0, v4.2) Upgrade SQL Server 6.5 to SQL Server 2005 RE: Upgrade SQL Server 6.5 to SQL Server 2005
David O
Hall of Fame
Points: 3228
More actions
January 23, 2009 at 9:13 am
#931864
If you made the jump to 2005 ok you should be able to use:
ALTER DATABASE database_name
SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }
to fix the compat level.
Good luck,