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

🧠 Microsoft 365 Copilot Studio Licensing: A Simple Guide

 If you're planning to build your own AI assistants (called copilots ) using Microsoft 365 Copilot Studio, it's important to underst...