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

X-Received	by 10.224.65.6 with SMTP id g6mr2678976qai.4.1366141290953; Tue, 16 Apr 2013 12:41:30 -0700 (PDT)
X-Received	by 10.49.110.99 with SMTP id hz3mr380332qeb.11.1366141290889; Tue, 16 Apr 2013 12:41:30 -0700 (PDT)
Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.glorb.com!ca1no47810581qab.0!news-out.google.com!ef9ni42436qab.0!nntp.google.com!cj1no2180034qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 16 Apr 2013 12:41:30 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=69.141.102.130; posting-account=zOJgLwkAAABUe9onuJoANR6TvsWrwvn-
NNTP-Posting-Host	69.141.102.130
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<e2ac4750-5862-4ae8-a3e2-8c9ea96b56f5@googlegroups.com> (permalink)
Subject	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
From	Sonny <hairnhenna@gmail.com>
Injection-Date	Tue, 16 Apr 2013 19:41:30 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1446

Show key headers only | 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