I am having two different database like 'LiveDB' and 'MFDB'
both are having a common table named 'TB_Transaction'
now i need to select all record that exist in both databases.
when i run the following query:
select * from LiveDB.Dbo.TB_Transaction
select * from MFDB.Dbo.TB_Transaction
this gives an error.
Reference to database and/or server name in 'livedb.dbo.tb_transaction' is not supported in this version of SQL Server.
Plz tell me what is the alternate way to accomplish this task.