• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1605
  • Last Modified:

HOW TO FIND OUT WHAT VERSION OF SQL YOU ARE RUNNING?

What's the easiest way in finding out what version of SQL a person is running?  You'd think going to Help>About would be it but not in SQL.  Is there a better way?

Thanks,

Vic
0
itsmevic
Asked:
itsmevic
  • 3
1 Solution
 
k_rasuriCommented:
select @@version
0
 
k_rasuriCommented:
run the above query in query analyzer
0
 
k_rasuriCommented:
sorry to spam your thread..but this gives better view than select

print @@version

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now