User guide

Installation & Setup User Guide
revision 143 — 131
Verifying the Database Upgrade
After the upgrade is complete, you should verify that the database upgraded to
SQL 2000 (version 8). To do this:
1. Click the Windows Start button, then select Programs > Microsoft SQL
Server > Query Analyzer.
2. In the Connect to SQL Server window:
• Click the […] button and select your local SQL server.
• Select the Start SQL Server if it is stopped checkbox.
• Select the SQL Server authentication radio button and enter your SQL
Server sa account’s Login name and Password.
•Click [OK].
3. In the SQL Query Analyzer window:
•In the Query pane, type the following:
sp_dbcmptlevel DBName
(Substitute the name of your database for DBName)
• Click <F5> to execute the query.
• The message that should be displayed is “The current compatibility
level is 80.” If any other number is displayed, the database upgrade was
not successful.