Link to home
Start Free TrialLog in
Avatar of cheyennep
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?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cheyennep
cheyennep

ASKER

Here are the results of SELECT @@VERSION:  Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)

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
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.....
Do you think it is safe for me to run this script?
sp_dbcmptlevel [[ @dbname = ] name]
[ , [ @new_cmptlevel = ] version]

I'm new and scared.
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.
Thank you all for your help - I am new but so far love the service