How can we find what service pack we are useing

Question

Post reply

How can we find what service pack we are useing

AAKR

SSCommitted

Points: 1586
More actions
September 19, 2011 at 12:46 pm

#244020

I have to search what service pack in each server can you please tell me how to come out from the situation
Thank you in advance:-)

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

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

SkyBVI SSCoach Points: 15128 More actions · Answer 1

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

AAKR SSCommitted Points: 1586 More actions · Answer 2

Thank you for the reply

how can we find out with instance like (sql server 9.0.1399) which one it can be applied

eccentricDBA SSCarpal Tunnel Points: 4844 More actions · Answer 3

I use the following site to keep up with patch versions

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

AAKR SSCommitted Points: 1586 More actions · Answer 4

eccentricDBA (9/19/2011)
I use the following site to keep up with patch versions
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

I am also searching for this page from last 2hrs you help me a lot thank you:-)