Friday, March 9, 2012

How do I find out what Service Packs have been installed?

I'm using SQL Server Express on Vista. I can't remember whether or not I installed the service packs for SSEE. Is there a quick and easy way to find out?

hi,

you can query som server properties as (on my running server)

SET NOCOUNT ON; SELECT CONVERT( varchar, SERVERPROPERTY('Edition')) AS Edition , CONVERT( varchar, SERVERPROPERTY('ProductVersion')) AS Version , CONVERT( varchar, SERVERPROPERTY('ProductLevel')) AS Level --< Edition Version Level Express Edition 9.00.3159.00 SP2

regards

No comments:

Post a Comment