How to retrieve all record from every table where id = 1 in MS SQL 2008 : How to retrieve all record from every table (Ex: table1, table2, table3, ... tableN ) where id = 1 from single database (EX: database1) in MS SQL 2008

Is this possible?