N a g a s a i: Quick Note: How to find out which Service Pack is installed on SQL Server?

Monday, April 30, 2018

Quick Note: How to find out which Service Pack is installed on SQL Server?

-- SQL Server 2000/2005/2008/2008R2/2012
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

-- SQL Server 6.5/7.0
SELECT @@VERSION

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)