中国IT动力,最新最全的IT技术教程
最新100篇 | 推荐100篇 | 专题100篇 | 排行榜 | 搜索 | 在线API文档
首 页 | 程序开发 | 操作系统 | 软件应用 | 图形图象 | 网络应用 | 精文荟萃 | 教育认证 | 硬件维护 | 未整理篇 | 站长教程
ASP JS PHP工程 ASP.NET 网站建设 UML J2EESUN .NET VC VB VFP 网络维护 数据库 DB2 SQL2000 Oracle Mysql
服务器 Win2000 Office C DreamWeaver FireWorks Flash PhotoShop 上网宝典 CorelDraw 协议大全 网络安全 微软认证
硬件维护  CPU  主板  硬盘  内存  显卡  显示器  键盘鼠标  声卡音箱  打印机  机箱电源  BIOS  网卡  C#  Java  Delphi  vs.net2005
  当前位置:> 程序开发 > 数据库开发 > 数据库综合
怎样手工删除数据库里的Merge Replication信息
作者:未知 时间:2004-12-15 12:12 出处:Blog 责编:chinaitpower
              摘要:暂无

1. The best way is to run sp_removedbreplication.

2. After you run sp_removedbreplication, you may run the following
script in your restored database. This script will generate the drop
commands for replication related system tables, views, stored procedures
and triggers. You may check the generated output first to make sure it
does not drop your own user object, and then run the output to drop
these information.


set nocount on
Select 'drop table ' + name from sysobjects
where name like '%conflict%' and type='u'

Select 'drop table ' + name from sysobjects
where name like 'MSMerge%' and type='u'

Select 'drop trigger ' + name from sysobjects
where type = 'tr' and status < 0 and category = 2

Select 'drop proc ' + name from sysobjects
where name like 'sp_%' and type ='p' and category = 2

Select 'drop proc ' + name from sysobjects
where name like 'sel_%' and type ='p' and category = 2

Select 'drop view ' + name from sysobjects
where name like 'tsvw%' and type ='v' and category = 2
Select 'drop view ' + name from sysobjects
where name like 'ctsv%' and type ='v' and category = 2


3. (optional step) you may use the steps in the following article to
make sure your user objects are no longer marked as being used in
replication (by change the replinfo column of the sysobjects to 0. This
steps is only needed if the replinfo column is not 0):

http://support.microsoft.com?id=326352

4. (optional step) check the steps in the following article to make sure
no columns are being marked as replicated:

http://support.microsoft.com?id=811899

关闭本页
 
首页 | 投资与合作 | 服务条款 | 隐私政策 | 收藏本站 | 设为首页 | 新用户注册 | 免责声明 | 使用帮助
Copyright ©2005-2008 chinaitpower.com All rights reserved. www.chinaitpower.com 版权所有