Troubleshooting SQL Server Synchronization Legal Issues

1. How to troubleshoot SQL Server synchronous replication
http://blog.csdn.net/roy_88/article/details/41481059

2. "Synchronous replication common error handling 1" You cannot insert a display value into a table when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, error code: 544)
Note: (The environment should be aware of the default values when sql2005/sql2008 configuration is released)
http://blog.csdn.net/roy_88/article/details/41448099

3, "Synchronous replication common error handling 2" Synchronous replication data caused by synchronization failure error
http://blog.csdn.net/roy_88/article/details/42301701

4, "Synchronous replication common error handling 3" Cannot find the stored procedure Sp_msins_tablename
http://blog.csdn.net/roy_88/article/details/42419675

Delete all publications under library:

Use [DataBaseName]

EXEC sp_removedbreplication

Go

Troubleshooting SQL Server Synchronization Legal Issues