What are the challenges you face when working across database platforms? Take the survey
Options

REQ: Change Database Name in Results if USE <database> in sc

tkdennistkdennis Posts: 114
edited September 27, 2010 7:05AM in SQL Multi Script
I have many databases on each SQL Instance, so my distribution lists are all set to master and I put the database name in the script. It would be nice if the results tab listed the database name from the USE statement that the SQL actually executed within, instead of every result showing the name from the distribution list.

This would include USE statements within dynamic SQL also
if exists (select 1 from sys.databases where name = 'db1')
	exec ('use db1;exec sp__spaceused ')
if exists (select 1 from sys.databases where name = 'db2')
	exec ('use db2;exec sp__spaceused ')

Thanks,
Traci
SMS 1.2.0.28

Comments

Sign In or Register to comment.