sql 2005 sp1

Question

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

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Run this:

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

If the results look like this: '9.00.2047.00 SP1 Standard Edition', you've got SP1.

Greg

Stephen Merkel Mr or Mrs. 500 Points: 518 More actions · Answer 2

Or.... just look at the server as listed in Object Explorer in SSMS ( Sql Server Management Server).

Where you will also see the '9.00.2047.00' that indicates SP1.