Procedure: usp_drop_multiple_databases
Description: This procedure will take a string as input (it can take the % character in the calling string), put all db like that name into a list, and then drop all the databases in the resultant list.
Example calling syntax:
usp_drop_multiple_databases 'test_%_delete'
--> Will drop ALL databases with a name like
'test_%_delete'
Note: Should be created in the master db and run with a master db connection.
Get a summarized report of all DataBases options
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
646 reads