Home Forums SQL Server 2005 Administering SQL Server syntax error RE: SQL Server syntax error
Ken Simmons
SSCertifiable
Points: 7822
More actions
July 1, 2009 at 7:41 am
#1018402
Kenneth Langner Jr. (7/1/2009)If this is SQL Server 2005 Try this:USE [master]GOEXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90GO
Kenneth Langner Jr. (7/1/2009)
USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90
That's right. I have been working with 2008 for too long. 🙂