MSSQL 2000 to 2005

[oldstudent]

How to upgrade MSSQL 2000 to 2005?

Plz help me !!!

[BASIS24x7]

hi there,

search for the document in www.way2sapbasis.com

regards
pavan

[rukku]

Who r u man

[hussaini]

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.