Visit our Google Group Way 2 SAP BASIS

MSSQL 2000 to 2005

Moderators: BASIS24x7, Rashed

MSSQL 2000 to 2005

Postby oldstudent »

How to upgrade MSSQL 2000 to 2005?

Plz help me !!!
Posts: 18

Postby BASIS24x7 »

hi there,

search for the document in

Site Admin
Posts: 27

Re: MSSQL 2000 to 2005

Postby rukku »

Who r u man
Posts: 39

Re: MSSQL 2000 to 2005

Postby hussaini »


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: --> 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.

Syed Hussaini.
SAP BASIS Consultant
Terrenos Software Technologies Pvt (Ltd).
Posts: 72

Return to Upgrades Forum

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our Google Group Way 2 SAP BASIS