Tuesday, April 28, 2015

How to determine your SQL Server Version, Service Pack, and Edition


Query to determine your SQL Server Version, Service Pack, and Edition

Connect to the instance of SQL Server, and then run the following query:

Select @@version



SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

No comments: