Post

Getting SQL Instance Edition or service pack for SQL 2012
I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on https://www.sharepointfire.com/?p=138 and it is still usable for SQL Server 2012 SELECT SERVERPROPERTY(‘Edition’) AS ‘Edition’, SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’, SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’, SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’, SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’ GO (It is possible you need to change the ‘)  

I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on https://www.sharepointfire.com/?p=138 and it is still usable for SQL Server 2012

SELECT
SERVERPROPERTY(‘Edition’) AS ‘Edition’,
SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’,
SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’,
SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’,
SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’
GO

(It is possible you need to change the ‘)

 

image

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archive