Removing unused or unneeded servers

Dave PendletonDave Pendleton Posts: 86 Bronze 3
edited June 18, 2008 5:48AM in SQL Multi Script
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.

Comments

  • Hi Dave,

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

    Regards,
    --
    Daniel
  • 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
Sign In or Register to comment.