Removing unused or unneeded servers

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Removing unused or unneeded servers

Postby Dave Pendleton » Fri Jun 13, 2008 4:57 am

How do I get rid of unused or unneeded servers from the Database Distribution List?

I frequently use instances of SQL Server on VM's and I don't want these appearing in my distribution lists after I've trashed them.

When I right-click on the server/instance, the remove option is disabled even though some of these instances were manually added and are now long gone.

Thanks.
Dave Pendleton
 
Posts: 46
Joined: Sun Aug 19, 2007 3:17 am
Location: St. Paul, MN

Postby dlkj » Mon Jun 16, 2008 3:34 pm

Hi Dave,

I've managed to reproduce this issue. I'll let you know when I have more information.

Regards,
--
Daniel
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge

Postby dlkj » Wed Jun 18, 2008 10:48 am

Hi Dave,

I need a bit more information to work out what is going wrong.

Could you first check if any of the trashed VM's are registered in SQL Server Management Studio.

Could you also send the following files to daniel.kenyon-Jones [AT] red-gate.com

C:\\Documents and Settings\\[YOUR LOGIN NAME]\\Application Data\\Red Gate\\SQL Multi Script\\Application.dat
C:\\Documents and Settings\\[YOUR LOGIN NAME]\\Application Data\\Red Gate\\SQL Multi Script\\Project.sms

and a list of the trashed vm names you are still seeing.

Thanks,
--
Daniel
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests