tags:

views:

41

answers:

1
+1  Q: 

about sql server merge statement

Hello everyone,

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

+2  A: 

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.

Ray  2010-05-09 13:32:00
You mean both source and target must be running on Sql server 2008? Or target must be on sql server 2008, but source (since source is always read only) could be on sql server 2005?
George2  2010-05-09 16:03:05
The merge statement (or any sql statement) can only run within the server instance where the database lives. So, while you may run a query on server A which accesses server B, what actually happens is that server A sends a sql statement to server B which server B must then run against its own database(s). If B is sql 2005, and the statement contains a 'merge', it won't be able to run it.
Ray  2010-05-09 17:18:50
Thanks, question answered!
George2  2010-05-10 02:42:30

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting