Friday, July 8, 2011

How to determine currently using SQL version or edition

To determine the version of SQL Server, you can use any of the Step 2 or Step 3:-


Step1:- Open an Sql instance and connect


step2:- Execute an query   Select @@version debug and run


step3:-  To know about Productversion, Product level and edition execute this below Query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

No comments:

Post a Comment

Why Power Automate Premium with AI Builder is a Game-Changer for Single Users

 I ntroduction Manual data processing is not only time-consuming but also prone to errors, impacting efficiency and decision-making. Organi...