September, 2011

Posts

| |

|

SQL's Corner

Replication: XML data loss occurs when Merge agent fails with Violation of Foreign Key

Posted over 2 years ago

by clsilva
- 0 Comments
Problem : Consider the following scenario: You use a merge publication operation to replicate XML data in Microsoft SQL Server 2005, in Microsoft SQL Server 2008, or in Microsoft SQL Server 2008 R2. A foreign key violation error occurs in...
SQL's Corner

Replication: What is the difference between Database Compatibility Mode and Publication Compatibility Mode

Posted over 2 years ago

by clsilva
- 0 Comments
Database Compatibility Mode : Compatibility level affects behaviors only for the specified database , not for the entire server. Compatibility level provides only partial backward compatibility with earlier versions of SQL Server. Use compatibility...
SQL's Corner

Replication: Snapshot agent execution causes system Available Memory to drop to 0 and possibly fail

Posted over 2 years ago

by clsilva
- 0 Comments
Problem : While running the snapshot agent, the available memory of the server goes down to 0 and snapshot may even fail. Should the snapshot complete, the memory is released very slowly. Cause : This is because in the current design (SQL 2005...