SQL Server Replication

Welcome to www.ReplicationAnswers.com - a community resource for SQL Server DBAs who are interested in learning more about SQL Server replication....

Please send any comments about articles etc to Paul.Ibison@ReplicationAnswers.Com.

Below is a list of the most recent additions to the site.

When you have a sec please check out this book for a decent addition to your SQL bookshelf.

There's loads of interesting content including a not-to-be-missed chapter (36) on a few undocumented replication techniques by yours truly ;). Finally, and importantly, it's a collaborative effort by 53 (MVP) authors who have each donated 100% of their royalties to War Child International.

Upgrading Databases to SQL Server 2008 - a few lessons learned	21st June 2010	Articles
Why do I get this error when editing a trigger? Msg 21531, Level 16, State 1, Procedure sp_MSmerge_altertrigger, Line 67 The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a republishing hierarchy, DDL commands can only be executed at the root Publisher, not at any of the republishing Subscribers. Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 191 The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message. Msg 3609, Level 16, State 2, Procedure mytrig1, Line 10 The transaction ended in the trigger. The batch has been aborted.	7th May 2010	Merge