September 29, 2006 at 1:56 pm
Hi,
I have just finished installing SQL Server 2005 on my workstation. I have local db named after my workstation name i.e xyz and then I connect to a server on network i.e. 10.2.0.3. Everything is fine,except that local db is shown with green(play type in dvd remotes) icon and grey circle icon next to remote i.e network db server which happens to be SQL SERVER 2000.
Is this MS way of saying/identifying LOCAL & REMOTE/NETWORK DATABASES???
Please clarify.
Thanks in advance.
October 2, 2006 at 5:49 am
Green with play = server is running
Red with stop = server is not running
Gray circle = unknown, being a remote server management studio hasn't tried to connect to it yet, thus doesn't know if it is running or not, I think this icon is supposed to be limited to the registered servers window.
There seems to be a slight bug though where a connection is made without its green icon and only shows the empty gray circle. I normally see this when connect to a server that has a gray circle in the registered servers list, it then appears in the object explorer with a gray circle and all other connections after that will also have a gray circle, ah well.
I don't think the managment studio has any way to tell between local/remote servers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply