Error 3724:Cannot drop the table 'object_name' because it is being used for replication.
来源:互联网 发布:淘宝网舞蹈扇子批发 编辑:程序博客网 时间:2024/04/29 23:38
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'object_name' because it is being used for replication.
当你试图删除或者变更一个table时,出现以下错误
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'object_name' because it is being used for replication.
比较典型的情况是该table曾经用于复制,但是后来又删除了复制
处理办法:
sp_configure 'allow updates', 1
go
reconfigure with override
go
begin transaction
update sysobjects set replinfo = '0' where replinfo >'0'
commit transaction
go
rollback transaction
go
sp_configure 'allow updates', 0
go
reconfigure with override
go
- Error 3724:Cannot drop the table 'object_name' because it is being used for replication.
- Error 3724:Cannot drop the table 'object_name' because it is being used for replication.
- Cannot drop the database ‘XXX’ because it is being used for replication.
- Cannot drop the database XXX because it is being used for replication
- The process cannot access the file XXX because it is being used by another process
- IIS:The process cannot access the file because it is being used by another process.
- FileStream:The process cannot access the file because it is being used by another process
- The process cannot access the file because it is being used by another process.
- Solution: The process cannot access the file [filename] because it is being used by another process.
- the process cannot access the file because it is being used by another process
- 拷贝文件时出现The process cannot access the file 'xxx' because it is being used by another process.错误
- 处理文件时遇到:The process cannot access the file because it is being used by another process.
- IIS ERROR about SP:The process can't access the file because it is being used by another process
- C#使用Create创建文件后,报The Process cannot access the file because it is being used by another process的异常
- C#使用Create创建文件后,报The Process cannot access the file because it is being used by another process的异常
- PostgreSQL中 drop table指令出现ERROR: cannot drop table userinfo because other objects depend on it
- Cannot drop the database 'databasename' because it is currently in use
- Cannot drop the database [NAME] because it is currently in use
- 2个经典的笑话
- JavaScript在页面间数据传输的使用
- Oracle10G Physical Standby Database笔记
- Blitz++ 计算二阶导数
- 游戏开发学习笔记(一)--采用何种语言开发
- Error 3724:Cannot drop the table 'object_name' because it is being used for replication.
- 韦小宝适合做IT人的8大理由
- 天下第一搞笑情书之英文版!
- Windows自动启动程序的十大藏身之所(转载)
- web标准的重要链接
- 大鱼与小鱼(转)
- .net中使用 crystal reports (水晶报表)的打包和部署问题
- 真的爱你
- [转]上下文广告: 智能网络广告的起点