How to find version of service pack?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

jmcgarvey Default port Points: 1489 More actions · Answer 1

You have a few ways:

1. In Query Analyzer enter: select @@version

2. In Enterprise Manager: Right click on the server name and select properties. It is on the first page.

3. Look in the first few lines of the SQL Server Logs under Management.

Finally, go to http://www.sqlsecurity.com and look under FAQs under the version tab to determine if you have any hot fixes or SP levels.

DKlein SSCrazy Points: 2351 More actions · Answer 2

SSCrazy

Points: 2351

March 20, 2007 at 1:51 pm

Thanks,

Step one worked just fine.