cheyennep
asked on
SQL database compatiblity level does not include SQL 2005
I am running SQL Server 2005 with a database that I am guessing was developed in SQL 2000. If I go into the database options the compatabilty level only goes up to SQL 2000 (80). I want it to be compatable with 2005. Mainly because I want to write a PIVOT script.
How can I "convert" this database from 2000 to 2005?
How can I "convert" this database from 2000 to 2005?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I guess you only installed/used the management studio, which is perfectly possible to connect to sql 2000.
chek your computer if you have several instances installed, the easiest is the computer management -> services list and see what "sql server" services you have there.
chek your computer if you have several instances installed, the easiest is the computer management -> services list and see what "sql server" services you have there.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In computer management under Services and Applications it has:
SQL server Configuration>SQL Server 2005 Services
and SQL Server 2005 Network Config and SQL Native Client Config.....
SQL server Configuration>SQL Server 2005 Services
and SQL Server 2005 Network Config and SQL Native Client Config.....
ASKER
Do you think it is safe for me to run this script?
sp_dbcmptlevel [[ @dbname = ] name]
[ , [ @new_cmptlevel = ] version]
I'm new and scared.
sp_dbcmptlevel [[ @dbname = ] name]
[ , [ @new_cmptlevel = ] version]
I'm new and scared.
ASKER
You guys are right. The database is version 8.0 under server properties general. Bummer. I guess I will have accomplish the PIVOT the old way.
The new PIVOT is not that helpful, you still have to explicitly list the columns in the statement anyway. Its a bit neater but it isn't dynamic.
ASKER
Thank you all for your help - I am new but so far love the service
ASKER
I feel really stupid. I swear I am using 2005 because it looks completely different than the 2000 server. This is what I get when I do "About"
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
Maybe I don't understand what you mean by "instance".
Thank you for your help