Version of SQL

[mekohler]

Hi, I was wondering about what version of SQL is installed on one of our servers. If I goto programs installed, it shows SQL Server 2005 is installed. But if I look in SQL Management Studio, the build on the this server is 8.0760 which I thought is a SQL 2000. The reason I ask is there are options missing, such as no credentials under security, no proxy option under SQL Server Agent and when I try to create a job, the option for integration services is missing for job steps. Do I need to upgrade this server or is it an incomplete install?
Thank you,
Michael Kohler

 

[gmmastros]

Run this in a query window:

SELECT SERVERPROPERTY('productversion'), 
       SERVERPROPERTY ('productlevel'), 
       SERVERPROPERTY ('edition')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

SELECT @@VERSION

That gives you a version of SQL Server as string.

BUT the George's suggestion gives you more detailed information about it. Also if you want to use version info in your FronEnd code George's suggestion ifs the way. If you want just to check the version, hmmm, my suggestion tell it on more human way


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[mekohler]

Thanks to both replies, it turns out the server I was concerned about is a SQL 2000.

 

[DrSql]

Here is a simple tool

http://www.brothersoft.com/sql-server-version-checker-download-32177.html

Dr.Sql
Good Luck.

 

[Zografski]

Try this

exec master..xp_msver

Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!