hi,

I have a SP created in a center DB A.
I created a table in A with one field dbname (15 db names)
DBname
db1
db2
db3
db4
..
..
..
..
..

I need to run that SP against all these tables listed in the table by loop
through.

How do I acomplish these by coding?

Thanks,

What does your stored procedure do to these tables? You might be able
to have it do dynamic SQL against a passed in databasename, similar to
the following:

DECLARE @DBName as VARCHAR(100)

SELECT @DBName = MIN(DBName) FROM A

WHILE @DBName IS NOT NULL
BEGIN --loop

EXEC('SELECT * FROM ' + @DBName + '.tablename')

SELECT @DBName = MIN(DBName) FROM A WHERE DBName > @DBName

END --loop

-Eric Isaacs

got it. Thanks
"Eric Isaacs" <eisaacs@gmail.com> wrote in message
news:a692603d-6ac3-4e7d-96db-2c54767368b7@56g2000hsm.googlegroups.com...
> What does your stored procedure do to these tables? You might be able
> to have it do dynamic SQL against a passed in databasename, similar to
> the following:
>
> DECLARE @DBName as VARCHAR(100)
>
> SELECT @DBName = MIN(DBName) FROM A
>
> WHILE @DBName IS NOT NULL
> BEGIN --loop
>
> EXEC('SELECT * FROM ' + @DBName + '.tablename')
>
> SELECT @DBName = MIN(DBName) FROM A WHERE DBName > @DBName
>
> END --loop
>
> -Eric Isaacs