DECLARE @db_name VARCHAR(50)
DECLARE daterbass CURSOR FOR
SELECT [name] AS "dbname" FROM master..sysdatabases
ORDER BY "dbname"
OPEN daterbass
FETCH NEXT FROM daterbass
INTO @db_name
SET NOCOUNT ON
WHILE @@FETCH_STATUS = 0
BEGIN
SET @strQuery = 'SELECT colA, colB '
SET @strQuery = @strQuery + ' FROM ' + @db_name
SET @strQuery = @strQuery + + ' ..MyTable '
SET @strQuery = @strQuery + ' WHERE conditions'
EXECUTE(@strQuery)
FETCH NEXT FROM daterbass
INTO @db_name
END
CLOSE daterbass
DEALLOCATE daterbass
SET NOCOUNT OFF