zenworksb
asked on
sql updates
i have been asked to patch the sql servers. we have two sql 2005 and three sql 2003 anything I should do watch out for thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how do I know what service pack I am on for 200sql and 2005 sql
select @@version
or right click on the server and select properties
don't confuse the os sp and the sql server sp...
or right click on the server and select properties
don't confuse the os sp and the sql server sp...
Service packs are cumulative, so you only need to apply the latest one for each version. I believe it is sp4 for SQL2000 and sp2 for SQL2005.
If possible, update a development system first and test that the application runs as expected.
Test your application after the install to verify that everything works as normal. If it does not, then you'll need to restore from the backups.