Hi,
in mssql 2000 system
goto enterprise manager
Execute update statistics for all database tables in the <SAPSID> database by
running the following SQL script:
use <SAPSID> exec sp_updatestats
make sure that:
You have backed up your SQL Server database before you perform the upgrade.
you not login with remote desktop.
and now start the installation of
mssql server 2005
Restart SQL Server.
Download and run the SAP tools from:
http://service.sap.com/msplatforms --> SQL Server
For information, see SAP Notes 799058 and 683447
Set the compatibility level of the database to 90 in the SQL Server Management Studio
as follows:
a. Right-click the SQL Server database.
b. Choose Properties and then Options.
done.