数据库不能改名称

当修改数据库时出现错误:

The database could not be exclusively locked to perform the operation.

以下方法可解决:

ALTER DATABASE spide SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database spide modify name = spider
ALTER DATABASE spider SET MULTI_USER

posted @ 2012-10-18 13:44  pantherbean  阅读(322)  评论(0编辑  收藏  举报