SQL 2K SP3 Scripts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2K SP3 Scripts

Does anyone know what the 7 scripts are called that are executed during the SP3 install? One of our SP3 installs ran all the way up to the last step, but it failed to execute the 7 scripts. There are a lot of sql scripts included, and I am trying to find out which 7 are run at the end of the install so we can run them manually. @@version returns 8.00.760, but I want to make sure we are fully installed. Thanks -dataninja- "The normalcy of a database is inversely proportional to that of it’s DBA."
Not sure specifically but I am fairly sure it is one of the repl*.sql scripts. However, my recommendation would be to run the install fully again rather than trying to step through what might not have been completed. Just my thoughts. David
Check for SQLSTP.LOG under windows directory, where you can find set of events logged while applying SP. If the version reflects the 8.00.760 which resembles it has SP3 installed. _________
Satya SKJ

..but be careful! Upgrading sql7 to sql2000 my upgrade process crashed. A bunch of scripts were not run, however, the sql server did report @@version as being 2000. But some of the client tools were not upgraded properly, and the server ended up in a bit of a mess. Manually running the scripts did not fix this fully
Chappy I believe originator is after SQL 2K SP3 not about Upgrade process. _________
Satya SKJ