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?