Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to check sql server version....

Author  Topic 

gvmk27
Starting Member

44 Posts

Posted - 2011-10-12 : 12:11:55
how to check sql server version from client tool.

I mean can we query for that ?

because some of my server versions are in 2005 / 2000, but my client tools are 2008 version.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-12 : 12:12:58
SELECT @@VERSION

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

gvmk27
Starting Member

44 Posts

Posted - 2011-10-12 : 12:14:54
Thanks Visakh..
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-12 : 12:22:21
wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-10-13 : 09:28:07
Also refer
http://beyondrelational.com/blogs/madhivanan/archive/2010/09/21/version-info.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -