about sql server merge statement
I am using SQL Server 2008 Enterprise DB and using the new Merge statement (when source and target are both SQL Server 2008 DB tables), and it works well. I have another database table which is hosted in SQL Server 2005 Enterprise DB. I want to know whether Merge statement could using one table of SQL Server 2008 as source, and another tableof SQL Server 2005 as target? The two databases may not exist on the same machine.
thanks in advance, George
No - the merge statement must be able to run on the sql server where you are inserting the records, and your 2005 instance wouldn't know what to do with it.