Cannot drop database "databasename" because it is currently in use.
来源:互联网 发布:新浪 算法工程师 编辑:程序博客网 时间:2024/06/04 18:52
有时候你在操作数据库的时候数据库出问题了,而你又要把数据库drop时就出问题了:Cannot drop database "databasename" because it is currently in use.
这时你只要按照以下方法做就可以了:
use master
go
alter database databasename set single_user with rollback immediate
go
drop database databasename
go
- Cannot drop database "databasename" because it is currently in use.
- Cannot drop the database 'databasename' because it is currently in use
- 删除数据库时提示数据库正在被使用,无法删除(Cannot drop database databasename because it is currently in use)。
- 删除数据库时提示数据库正在被使用,无法删除(Cannot drop database databasename because it is currently in use)的问题
- 删除数据库时提示数据库正在被使用,无法删除(Cannot drop database databasename because it is currently in use)的问题
- Cannot drop the database [NAME] because it is currently in use
- Cannot drop the database ‘XXX’ because it is being used for replication.
- Cannot drop the database XXX because it is being used for replication
- It is currently in use by another gradle instance
- APP-SQLAP-10380:You cannot select this payment document because it is in use by another payment batch
- APP-SQLAP-10380: You cannot select this payment document because it is in use by another payment
- FMDB多线程下"is currently in use" 或者 "database is locked" 已解决!
- FMDB多线程下"is currently in use" 或者 "database is locked" 问题
- FMDB多线程下"is currently in use" 或者 "database is locked" 问题
- FMDB多线程下"is currently in use" 或者 "database is locked" 问题
- ios FMDB多线程"is currently in use", "database is locked"问题的解决
- 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.
- VS2005 中使用MSchart
- RTMP协议分析
- freemarker模板加载
- [feature phone系列]GSM网络框架浏览
- 信号(Signal)与槽(Slot)-Qt中的典型机制
- Cannot drop database "databasename" because it is currently in use.
- 通过Partition把map的结果输出到到n个不同的reduce
- UIImage应用与内存管理
- 《运算符的重载1》
- 内存检测
- 解决warning: no newline at end of file
- Handler 机制浅析及Message的异步加载
- 关于Unable to find a 'userdata.img' file for ABI armeabi to copy into the AVD folder的错误
- android单元测试