October 9, 2008 at 10:02 am
I open my servers in 2005 and we have bunch of servers still in 2000 enviroment, how do I know which enviroment is I am inn? Thank you
October 9, 2008 at 10:05 am
If you are using SQL 2005 Management Studio then you can see the server version as 8.xx on object explorer, else you can use select @@Version to check the server version both SQL and windows version
🙂
October 9, 2008 at 10:07 am
yulichka (10/9/2008)
I open my servers in 2005 and we have bunch of servers still in 2000 enviroment, how do I know which enviroment is I am inn? Thank you
One of those should do it:
select @@version
select serverproperty('ProductVersion')
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 9, 2008 at 10:14 am
Thank you very much
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply