Can someone tell me how I might substitute the database name in a query that spans multiple databases with a variable so it can be passed to the stored procedure? EX.

DECLARE @Database1 varchar(30)

SET @Database = 'Database1'

SELECT sf.filename
FROM @Database..sysfiles sf
INNER JOIN @Database..sysfiles1 sf1 ON sf.fileid = sf1.fileid