var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: backup of SQL Server 2000 loading to 2005
I want to restore a backup of a SQL Server 2000 database to SQL Server 2005. Would I need to do anything after running the restore to upgrade the database?
Not really. When the database is restored, it will be in SQL 2000 compatibility mode, so you will not be able to use any of the new bells and whistles. To fix that, you just run
sp_dbcmptlevel dbname, 90