https://blog.youkuaiyun.com/arrow_gxzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/arrow_gx/article/details/14522961https://blog.youkuaiyun.com/arrow_gx/article/details/14522961arrow_gxFri, 08 Nov 2013 15:43:24 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/9301835https://blog.youkuaiyun.com/arrow_gx/article/details/9301835arrow_gxThu, 11 Jul 2013 16:15:42 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/7328878https://blog.youkuaiyun.com/arrow_gx/article/details/7328878arrow_gxWed, 07 Mar 2012 14:51:18 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/7311947https://blog.youkuaiyun.com/arrow_gx/article/details/7311947arrow_gxFri, 02 Mar 2012 13:36:34 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/7251674https://blog.youkuaiyun.com/arrow_gx/article/details/7251674arrow_gxSat, 11 Feb 2012 21:46:27 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/6397404https://blog.youkuaiyun.com/arrow_gx/article/details/6397404arrow_gxThu, 05 May 2011 16:41:00 +0800注意：发布时须使用备份文件进行发布
 
更改字段
1：停止相关业务工作流，确保对需要修改字段的表没有任何数据操作
2：在发布中删除需要修改字段的表的发布
3：在订阅库中，直接修改字段
4：在发布库中，直接修改字段
5：在发布中，重新选择这个表
6：手工测试发布和订阅在该表上是否同步
7：回复相关业务工作流程
 
新添发布表
1：在发布数据库和订阅数据库上直接创建完全一样的表https://blog.youkuaiyun.com/arrow_gx/article/details/6397261https://blog.youkuaiyun.com/arrow_gx/article/details/6397261arrow_gxThu, 05 May 2011 16:21:00 +08001
Replication-replication distribution subsystem agent null failed. the publication XXX does not exist
从字面上可以看到，当前订阅的发布已经不存在了，而相应的分发代理却因为某些原因没有被删除，继续运行，就会出现这种错误。
这个错误可以在distributor的错误日志中，或者MSrepl_errors表中看到.
A1 如何解决：在distributo]]>https://blog.youkuaiyun.com/arrow_gx/article/details/6370134https://blog.youkuaiyun.com/arrow_gx/article/details/6370134arrow_gxThu, 28 Apr 2011 17:15:00 +08001、在发布服务器上创建一个发布。
2、发布属性中的订阅选项，设置允许从备份文件初始化为true，默认是false。
3、在发布服务器上暂停分发日志的清理作业（否则可能出现事物被清理而无法创建订阅的错误），备份数据库，发布服务器上保留备份文件，后面要用。
4、在订阅服务器上使用刚才的备份还原数据库，删除订阅服务器上数据库的触发器。
5、在发布服务器上执行sp_addsubscription存储过程添加订阅，脚本如下：
exec sp_addsubs]]>https://blog.youkuaiyun.com/arrow_gx/article/details/6154544https://blog.youkuaiyun.com/arrow_gx/article/details/6154544arrow_gxThu, 20 Jan 2011 12:24:00 +0800alter function sql_split
(
 @str varchar(1024),  --要分割的字符串
 @split varchar(10),  --分隔符号
 @index int --取第几个元素
)
returns varchar(1024)
as
begin
 declare @split_str varchar(1024)
 declare @location inthttps://blog.youkuaiyun.com/arrow_gx/article/details/5791964https://blog.youkuaiyun.com/arrow_gx/article/details/5791964arrow_gxThu, 05 Aug 2010 23:45:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/4232335https://blog.youkuaiyun.com/arrow_gx/article/details/4232335arrow_gxMon, 01 Jun 2009 13:26:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/4004938https://blog.youkuaiyun.com/arrow_gx/article/details/4004938arrow_gxThu, 19 Mar 2009 16:28:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2527641https://blog.youkuaiyun.com/arrow_gx/article/details/2527641arrow_gxMon, 09 Jun 2008 17:31:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2501368https://blog.youkuaiyun.com/arrow_gx/article/details/2501368arrow_gxSun, 01 Jun 2008 19:10:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2493486https://blog.youkuaiyun.com/arrow_gx/article/details/2493486arrow_gxThu, 29 May 2008 15:18:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2493454https://blog.youkuaiyun.com/arrow_gx/article/details/2493454arrow_gxThu, 29 May 2008 15:09:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2493445https://blog.youkuaiyun.com/arrow_gx/article/details/2493445arrow_gxThu, 29 May 2008 15:07:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2492649https://blog.youkuaiyun.com/arrow_gx/article/details/2492649arrow_gxThu, 29 May 2008 11:04:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2491197https://blog.youkuaiyun.com/arrow_gx/article/details/2491197arrow_gxWed, 28 May 2008 17:42:00 +0800https://blog.youkuaiyun.com/arrow_gx/article/details/2483155https://blog.youkuaiyun.com/arrow_gx/article/details/2483155arrow_gxMon, 26 May 2008 16:59:00 +0800