I am attempting to write a tsql script that will replicate a given operation across all databases on a given sql server (they all have the same tables, sp's etc). So far, I have written the code below. But I don't know of a way to reference a variable name in a tsql statement, or perform the equivalent of macro substition in vfp
For example, for each database in the schema, I want to be able to 'use it', and then do some further operation on it, like create a stored procedure. But the code doesnt work. In the code below the USE statement (which is commented out) doesn't work, nor does the statement:
select * from @ccatlogname.archived

Is this possible in tsql?

TIA




declare @cCatalogName char(100)

declare dblist scroll cursor
for
select catalog_name from master.information_schema.schemata

OPEN dblist



FETCH NEXT FROM dblist
INTO @cCatalogName
print @ccatalogname
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM dblist
INTO @cCatalogName
SET @ccatalogname=rtrim(@ccatalogname)
print @ccatalogname

/*use @ccatalogname */
select * from @ccatlogname.archived
END

CLOSE dblist
deallocate dblist