Thursday, November 07, 2013

How to check SQL Server Version


Below are the queries which can be used to check the version of sql server on which you are running the query
copy these query in query analyzer window and chaeck the version.

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

SELECT @@VERSION

No comments:

Post a Comment