Which service pack is installed in the database

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Run this query:

select @@version

Then take the results and compare them to the list at:

http://www.sqlsecurity.com go to the SQLSecurity Checklist.

This list is also on Microsoft's site and it might be on this site also, but I don't know the paths to them.

-SQLBill

raotlm Old Hand Points: 325 More actions · Answer 2

Thank you SQLBILL. I do appreciate your quick answer.

Once again Thanks,

Rao

Run this query:

select @@version

Then take the results and compare them to the list at:

http://www.sqlsecurity.com go to the SQLSecurity Checklist.

This list is also on Microsoft's site and it might be on this site also, but I don't know the paths to them.

-SQLBill

[/quote]

SQLBill SSC Guru Points: 51440 More actions · Answer 3

BTW- I just found this cool page of information on this site.

Specifically, it shows the use of

SELECT SERVERPROPERY('productlevel')

That will return the 'readable' version of your SQL Server product. I ran that command on my SQL Server and it returned:

SP3

Plain and simple.

-SQLBill

raotlm Old Hand Points: 325 More actions · Answer 4

SQLBill,

I also found the followign link at MS. This link explains how to find the version and release numbers for different versions of SQL Server.

I am new to using this e-mail and I did not know how to put a link. Please cut and paste the above link into your browser.

Rao