Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1446

Have a trigger that I need to run on all databases thare are in the domain.dbname table. Dont want to run it manually on each db

Show all headers | View raw

I have a trigger that I need to run on all application databases that are in the domain.database(Table.Coloum) of a SLSYSTEM Database
So if I do a select databasename from domain on the system database I get the 250+ Application database name. So I want to run a Trigger SQL Script on each of the 250+ application databases. 
Is there some way I can create a script to do this for all the databases in the domain.databasename of the SLSYSTEM database.

Thanks so much in advance.

Sonny

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Have a trigger that I need to run on all databases thare are in the domain.dbname table. Dont want to run it manually on each db Sonny <hairnhenna@gmail.com> - 2013-04-16 12:41 -0700

csiph-web