Posted by Fran on 04/10/07 15:15

(SQL 2005)
I'm looking to create a stored procedure to first "select name from
sys.databases where name like '%site'" then pass each name to the
following using some kind of loop "USE @name select name from
sys.tables where type = 'U'"
I tried a while statement, but the master sys.databases recordset
doesn't change..

It's the loop I can't get to work.

Any help is greatly appreciated!

[Back to original message]