How do you find out the loaded service pack

[Mack2]

When I connect to a database, I am getting an error message saying I need to load a new service pack. How do I determine what service pack I have currently installed? Thanks!!

 

[vongrunt]

Go to EM, drill down to server, right-click Properties.

Or run this query:

SELECT SERVERPROPERTY('Edition'), SERVERPROPERTY('ProductLevel')

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Mack2]

thanks for the help. I ran the script, but it did not tell me the service pack I was using. The second column said I was using RTM. I will start a new thread asking what rtm is. Thank!!