i hava 10 more database the database name is 'account_20110310' to 'account_20110320'
the 'Operations' is table of each database are same field ant type
i want to select all field of tabale 'Operations' from all database
i passed the query bellow but occur error
declare @qry nvarchar(max)
SET @qry='SELECT Operations.* FROM '+
'sys.databases WHERE NAME LIKE account_%'+'..'+'Operations'
EXEC(@qry)
please help me