Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2007-08-07
4
Medium Priority
?
1,601 Views
Last Modified: 2009-12-16
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
Comment
Question by:itsmevic
  • 3
4 Comments
 
LVL 8

Expert Comment

by:k_rasuri
ID: 19650011
select @@version
0
 
LVL 8

Expert Comment

by:k_rasuri
ID: 19650020
run the above query in query analyzer
0
 
LVL 8

Accepted Solution

by:
k_rasuri earned 2000 total points
ID: 19650037
sorry to spam your thread..but this gives better view than select

print @@version

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question