Is SP1 loaded?

How can I check (where can I check) to see if SP1 was loaded onto a server?
I checked Help, About. I check Control Panel. Any other suggestions?Hi Diane
If you want to check whether SP1 was applied to your SQL Server, run this:
SELECT SERVERPROPERTY('ProductLevel')
HTH
Kalen Delaney, SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:D1283EA1-96E0-48A2-B6B6-94E52EC28BBA@.microsoft.com...
> How can I check (where can I check) to see if SP1 was loaded onto a
> server?
> I checked Help, About. I check Control Panel. Any other suggestions?

Is SP1 loaded?

How can I check (where can I check) to see if SP1 was loaded onto a server?
I checked Help, About. I check Control Panel. Any other suggestions?Hi Diane
If you want to check whether SP1 was applied to your SQL Server, run this:
SELECT SERVERPROPERTY('ProductLevel')
--
HTH
Kalen Delaney, SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:D1283EA1-96E0-48A2-B6B6-94E52EC28BBA@.microsoft.com...
> How can I check (where can I check) to see if SP1 was loaded onto a
> server?
> I checked Help, About. I check Control Panel. Any other suggestions?