instance list

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

instance list

Postby jrandall » Tue Sep 01, 2009 5:17 pm

How does one manage the SQL Server instance list? I want to delete/drop a SQL Server instance ( 2 actually) that no longer exists. I can add an instance, how do I drop one?
jrandall
 
Posts: 24
Joined: Thu Mar 13, 2008 8:51 pm

Postby Matthew Flatt » Wed Sep 02, 2009 8:17 pm

Hi Jrandall,

From what I'm aware there isn't a guaranteed way of removing servers from this list. It seems to get cached eventually disappears after a period of time. Have you tried rebooting the machine that runs SQL Dependency Tracker? I know that has worked previously but not all of the time.

Sorry I can't be more help!
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

instance list

Postby jrandall » Wed Sep 02, 2009 8:21 pm

I'm running Dependency Tracker on my laptop. It gets rebooted daily. I hadn't run Dependency Tracker in weeks.
jrandall
 
Posts: 24
Joined: Thu Mar 13, 2008 8:51 pm

Postby Matthew Flatt » Thu Sep 03, 2009 7:07 pm

Hi,

Do you have those servers still added to SSMS/Enterprise Manager/Query Analyzer? If they are added there that would cause them to always appear in the Dependency Tracker list. Removing them may do the trick. Also if you let SSMS/EM search for servers do those appear?

Thanks
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

instance list

Postby jrandall » Thu Sep 03, 2009 7:27 pm

Finally figured this out. I had previously removed those servers from my alias list in SQL Server Configuration Mgr. Forgot I still had them listed as Registered Servers in SSMS. That is where Dependency Tracker was picking them up. When I deleted them as registered servers, they no longer appeared in Dependency Tracker
jrandall
 
Posts: 24
Joined: Thu Mar 13, 2008 8:51 pm


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests