CODEWITHSUNDEEP
sqlsql-server-2005sql-server-2008sql-server-2000
ravidev
ravidev

Reputation: 2738

SQL server compability level issue - disabled

I have one database named TransportDB whose compatibility level is set to SQL Server 2000 (80). I want to change the compatibility level of this DB to SQL Server 2005 (90) or 2008 (100), but when I go to change this using Properties-->Options-->Compatibility level, I found that this compatibility level option is disabled i.e. I can't change the compatibility level.

I want to know how to change compatibility level and if I will change it, will this effect my current database or records in any way?

Upvotes: 2

Views: 1107

Answers (1)

Emir Akaydın
Emir Akaydın

Reputation: 5823

Try this SQL

EXEC sp_dbcmptlevel @dbname = 'TransportDB', @new_cmptlevel = 90;

You can use different values for @new_cmptlevel of course.

Upvotes: 1

Related Questions