How do I determine if SP1 is installed on SQL server 2008?

Question

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

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

You can use SERVERPROPERTY function to get the details of SP..

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 2

Use it like this:

SELECT SERVERPROPERTY('ProductLevel') as SPVersion

Raffael Schiller SSC Journeyman Points: 84 More actions · Answer 3

SSC Journeyman

Points: 84

July 26, 2010 at 4:55 am

Thanks ColdCoffee - works a treat

Regards

Raffael

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 4

SSC-Dedicated

Points: 39972

July 26, 2010 at 5:20 am

My pleasure, Raffael! 🙂