you can install sql 2005 side-by-side with sql 2000 but there will be only one default instance &  in this case SQL 2005 will be named isntance. do search for...

i forgot add that if your are going for SQL 2005 & thorough test as not done on 7.0 database then i recommend to keep backward compatibility for your 7.0...

As you have restore MSDB then see if "sp_change_users_login" is any helpful.

you need to contact Microsoft if they can replace for you based on your license key. before upgrade i am sure you have all last good known backups including System...

in this incidence there is drastic change of distribution statistics on all index keys. try to look from application side whether it is calling store procedure or making adoc's query....

Before you start installing SQL Server your SAN should be configured & your OS will be able to see Drive's. try to get information about how SAN LUN's are configured in...

Provide more info about which ERP is running on SQL2K is it Peoplesoft or SAP. as both ERP as there on way of doing Indexes. If it is peoplesoft then...

nice article, but besides stating CTE as a neat way to implement recursive queries. this article is missing concept & meaning about CTE.

I am curious to know in reference to this article

a>whether any dynamice sql statement were created within store procedure

b> is it possible to splitting it into multiple small stored procedures and calling...

I was not sure about what this "m_freeData" after doing DBCC PAGE, but you explained well.

Thanks for your feedback,

Thanks

Jay

Steve,

thanks for your reply, i tried using DBCC PAGE & didn't see the PAGE size in the result or i might be looking at the wrong place. i agree to...

as you stated the error message "Warning: The table 'IISLog' has been created but its maximum row size (13625) exceeds the maximum number of bytes per row (8060). INSERT or...

Michael:

Your comments\suggestion are informative, thanks for making very clear.

changing cmptlevel from 90 to 80 or vice versa is not going to help, as the moment when SQL server 2000 Database is been attached or restored to SQL Server...

can you see if there is stack dump for e.g. C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0030.txt

If there is then can you please post that up, as that might give some more...