Saturday, 15 March 2014

How to check SQl Server Edition .Product Version,Product Level

How to check SQl Server Edition :




with the help of this single line query you can check which Edition of server you are using:
--Query
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


It gives you this output as below:


No comments:

Post a Comment

Note: only a member of this blog may post a comment.