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')

🚀Microsoft Copilot – Free vs. Licensed vs. Copilot Studio (Complete Guide)

Artificial Intelligence is rapidly transforming workplace productivity. Microsoft’s Copilot ecosystem is at the heart of this shift, but the...