Run for all databases on a selected SQL Server Instance

Single-click script execution on multiple SQL Servers.

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

Run for all databases on a selected SQL Server Instance

Postby JDS » Mon Sep 08, 2008 11:29 pm

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.
JDS
 
Posts: 18
Joined: Fri Oct 27, 2006 6:43 pm

Postby HJoyce » Thu Sep 11, 2008 10:00 am

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'.
HJoyce
 
Posts: 150
Joined: Mon Oct 10, 2005 9:48 am

Postby JDS » Thu Sep 11, 2008 5:12 pm

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.
JDS
 
Posts: 18
Joined: Fri Oct 27, 2006 6:43 pm

Postby JDS » Tue Sep 22, 2009 3:51 pm

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.
JDS
 
Posts: 18
Joined: Fri Oct 27, 2006 6:43 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests