Cannot drop the database 'databasename' because it is currently in use
来源:互联网 发布:淘宝店铺名字在哪里改 编辑:程序博客网 时间:2024/05/17 01:04
when you drop datebase with SQLCMD tool, and met the error message as title, you can try below script.
---script start---
use master
go
alter database databasename set single_user with rollback immediate
go
drop database databasename
go
---script stop---
the parameter be marked with yellow is important
- 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 the database [NAME] 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 ‘XXX’ because it is being used for replication.
- Cannot drop the database XXX because it is being used for replication
- 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.
- 打开workspace时报错:could not launch the application because the associated workspace is currently in use
- 打开ecplise时报错:could not launch the application because the associated workspace is currently in use
- Exclusive access could not be obtained because the database is in use
- Ecplise导入工程报Cannot import *** because the project name is in use问题
- Ecplise导入工程报Cannot import *** because the project name is in use问题
- The Simulator can't be launched because it is already in use.
- Xcode The Simulator can't be launched because it is already in use .
- The Simulator can't be launched because it is already in use.
- 转贴 - 如何在 Linux 下调试动态链接库
- Visual c++ 2010入门
- 编程技术备忘—响应按钮的down,up事件
- SQLServer 2005 和自增长主键identity说再见——NEWSEQUENTIALID()
- dojo.coords简析
- Cannot drop the database 'databasename' because it is currently in use
- s3c2440存储控制器和地址以及启动的理解
- WIN_DOS经典大全
- MessageBox换行
- XP启用Guest却无法访问网络怎么办
- windows内核情景分析学习笔记6
- Table 单元格重叠变粗 使用border-collapse:collapse; 可以解决
- GLSL教程2
- VC 2010的重大变化