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 2005 Forums
 SQL Server Administration (2005)
 server status

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-03 : 10:55:16

Hi Gurus,

While iam connecting to servers through management studio iam facing
iam seeing like few servers are connected with Green colour (like>)and few are connected with circle as white.Frm these how can i decide the server status.

Is there any comand to view server status ?


Thanks,
ServerTeam

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-03 : 11:22:39
That's not the correct way that you could be able to decide (Server is online or offline).

You need to connect to the server Double Click on the server and check the DB's Property.

Manoj
MCP, MCTS
Go to Top of Page

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-03 : 11:34:23
Thank you.

But i did not get actual answer.
As server with while colour and server with green colour



Thanks,
ServerTeam
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-03 : 16:13:51
Server is online if you can see dbs on it in ssms.
Go to Top of Page
   

- Advertisement -