修改数据库 逻辑文件名称

select spid
from master.dbo.sysprocesses
where dbid=db_id('DTcmsdb2')

kill 51

exec sp_dboption 'DTcmsdb2','single user','true'
exec sp_renamedb 'DTcmsdb2','qzbxw'
exec sp_dboption 'qzbxw','single user','false'

原文地址:https://www.cnblogs.com/Lin267307031/p/3240706.html