To get around this problem I have to explicitly set @loopback_detection = 'false' in the call to sp_addsubscription. Keep in mind that...
SQL Server 2008 has a different definition of loopback detection. In SS2000, the same table would need to be replicated bidirectionally in order to...
This may be a SS2008 bug: http://connect.microsoft.com/SQLServer/feedback/details/377555/issue-with-2-way-in-replication If anyone else is having...
The problem is the same no matter what compatibility mode the databases are set to. I have tried 80 and 100 with the same results.
I haven't found an explanation yet. I have created a simpler test trigger than the one I run in production and it has the same problems in SQL...
I am using bidirectional transactional replication between SQL Server 2008 databases. Publisher A replicates an insert to the subsciber table on...
Here is a thought. If the article's table has a unique constraint and you update that column, the update will replicate as a delete/insert pair of...
I use bidirectional transactional replication in SS2000 SP4. I just upgraded my test environment from SS2000 to SS2008. In SS2000 Enterprise...
I am designing a two node multi-instance SQL Server 2005 cluster and I have questions about the requirements for the shared cluster resources. How...
Separate names with a comma.