Hi,

Pardon my ignorance, but can anybody tell me if it is possible

1) to do a single query that will retrieve records from 2 tables that are in different databases ?

2) Or is it possible use any sort of T-SQL command that will help me copy data from Table1 in Database1 to Table2 in Database2 ?



Thanks!