Red Gate forums :: View topic - Database Distribution List Sort
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Database Distribution List Sort

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dsheerin



Joined: 25 Sep 2008
Posts: 4
Location: Raleigh, North Carolina

PostPosted: Thu Sep 25, 2008 5:15 pm    Post subject: Database Distribution List Sort Reply with quote

Is there a workaround for sorting a database distribution list? I've looked for registry entries and config files with the distribution list information but have not been able to find where it is stored. I have hundreds of servers and having them out of order can be maddening at times.

I know that there is a enhancement request to get this functionality in a future release, but until then is there anything I can do to get my servers ordered in a way that I can locate one in a long distribution list.
Back to top
View user's profile Send private message
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Thu Sep 25, 2008 5:57 pm    Post subject: Reply with quote

Hi,

The distribution lists are stored in two files, both located in:
Code:
C:\Documents and Settings\[username]\Application Data\Red Gate\SQL Multi Script

Application.dat contains all the distribution lists you've got configured, and Project.sms contains (amongst other things) the actively selected one. I'd advise selecting a different distribution list than the one you want to edit, and exiting SQL Multi Script, before making any changes to Application.dat, or it might fall out of sync.

Note that editing these files by hand isn't something we support, and could end up leaving the application in an "interesting" state, but you should be able to just delete them and get back to a default state if anything does go wrong. Better yet, take a backup of them before doing anything!

Hope that helps,
Robert
_________________
Robert Chipperfield
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
dsheerin



Joined: 25 Sep 2008
Posts: 4
Location: Raleigh, North Carolina

PostPosted: Thu Sep 25, 2008 6:26 pm    Post subject: Reply with quote

Yes! That worked perfectly. I made a backup of the Application.dat file just in case but it wasn't needed. Very Happy I hope that RedGate will get around to making the enhancement to allow for sorting of the distribution lists sometime in the near future. This work around will do for now.

Thanks Robert.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group