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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.