SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 How do I tell what SPs have been applied?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 07/18/2003 :  11:48:23  Show Profile
How do I tell what Service Packs have been applied to my SQL 7 server?

Also, should I apply SP 4 before upgrading to 2k?


Almighty SQL Goddess

38114 Posts

Posted - 07/18/2003 :  12:32:31  Show Profile  Visit tkizer's Homepage
Run SELECT @@VERSION in Query Analyzer.

It is always a good idea to be on the latest service pack when the service pack has been out for a while. Service pack 4 is not required to upgrade to 2000 though, but yes go ahead and apply it.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000