| Author |
Message |
dsheerin
Joined: 25 Sep 2008
Posts: 4
Location: Raleigh, North Carolina
|
 Posted: Thu Sep 25, 2008 5:15 pm Post subject: Database Distribution List Sort |
 |
|
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 |
|
 |
Robert
Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK
|
| Posted: Thu Sep 25, 2008 5:57 pm Post subject: |
|
|
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 |
|
|
dsheerin
Joined: 25 Sep 2008
Posts: 4
Location: Raleigh, North Carolina
|
| Posted: Thu Sep 25, 2008 6:26 pm Post subject: |
|
|
Yes! That worked perfectly. I made a backup of the Application.dat file just in case but it wasn't needed.  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 |
|
|
|
|
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
