How can we help you today?

How to identify the SQL Server Version and Edition?

Issue
How can I identify the SQL version being used?

Product Line
SQL

Environment
SQL Server
SQL Server Management Studio

Resolution

  1. Open up SQL Server Management Studio. Connect to the SQL Server database.
  2. Create a New Query. Type SELECT @@VERSION.
  3. Run query. The output may have to be extended by dragging the column header to the right to see the full SQL Server version and edition.

SQL Server SELECT @@VERSION

See the Latest updates and version history for SQL Server for release notes and updates.

Schneider Electric Canada

Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more

Need help?

Need help?

Product Selector

Product Selector

Quickly and easily find the right products and accessories for your applications.

Get a Quote

Get a Quote

Start your sales inquiry online and en expert will connect with you.

Where to buy?

Where to buy?

Easily find the nearest Schneider Electric distributor in your location.

Help Center

Help Center

Find support resources for all your needs, in one place.

  • Help and Contact Center
  • Contact Sales
  • Find our Offices
  • Where to Buy
  • Careers
  • Company Profile
  • Investors
  • Newsroom
  • Report a Misconduct
  • Product Documentation
  • Product Selectors
  • Software and Firmware
  • Product Substitution and Replacement
  • Blog
  • Events
  • Schneider Electric Community
  • Sustainability
  • Legal Information
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings