December 2, 2008 at 1:56 pm
I am reviewing a SQL 2005 instance with multiple databases. One has been set to SQL 7 compatibilty mode.
Is there a way to check this DB to determine if it can be changed to SQL 2005 mode? SQL Analyzer will not run accross a SQL 2005. Does anyone know of another method to test this one DB?
December 3, 2008 at 11:03 am
SQL Server 2005 Upgrade Advisor?
Give it a try, I don't know if it'll work in your case, it should
December 3, 2008 at 11:18 am
Obviously change to the database name you want to check...
exec sp_dbcmptlevel 'master'
A.J.
DBA with an attitude
December 3, 2008 at 11:45 am
I tried this, it wont run across SQL 2005.
Problem with this client is that no one has left documentation.
December 3, 2008 at 12:01 pm
What happens when you try to run this in Management Studio? Do you get an error? What happens?
A.J.
DBA with an attitude
December 3, 2008 at 12:54 pm
Thank you for your responce
Sorry, misunderstanding. My reply was to the suggestion to run the Upgrade Analyzer which does not run on SQL 2005. However, I did run the command above on the databases and it only returned what I already knew. That being the database is set to SQL 7.0 compatibility mode.
I was hoping to test this database to see if I could raise it to 2005 mode.
Any further suggestions would be appreciated
thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply