Red Gate forums :: View topic - Run for all databases on a selected SQL Server Instance
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

Run for all databases on a selected SQL Server Instance

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



Joined: 27 Oct 2006
Posts: 18

PostPosted: Mon Sep 08, 2008 11:29 pm    Post subject: Run for all databases on a selected SQL Server Instance Reply with quote

In my environment the databases list is somewhat dynamic in terms of new databases created and databases removed. It would be helpful if you could select the SQL Server instance and the tool would run for all the databases accessible. Right now if you double click on the instance only master is added to the list.
Back to top
View user's profile Send private message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Thu Sep 11, 2008 10:00 am    Post subject: Reply with quote

Hello,

If you select the SQL Server instance and right click you can select the option to 'Add All Databases on this SQL Server to Distribution List'.
Back to top
View user's profile Send private message Send e-mail
JDS



Joined: 27 Oct 2006
Posts: 18

PostPosted: Thu Sep 11, 2008 5:12 pm    Post subject: Reply with quote

The solution works once but if I reuse the list I always have to check the list of databases to make sure that none have been added. Not truely all available databases.
Back to top
View user's profile Send private message
JDS



Joined: 27 Oct 2006
Posts: 18

PostPosted: Tue Sep 22, 2009 3:51 pm    Post subject: Reply with quote

Just revisiting this post since it has been painful to me again through a period of rapid database existence changes both adds and removes. I think this would be a great feature to be able to add all databases or all "user" databases like the feature available in maintence plans for a SQL Server instance. Having storable lists of servers is great unless you have to check them every time you runa script to make sure none are missing or extras that no longer exist.
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