Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

4 views
Skip to first unread message

Sonny

unread,
Apr 16, 2013, 3:41:30 PM4/16/13
to
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
0 new messages