修改数据库 逻辑文件名称

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'

 

 

posted @ 2013-08-06 15:49  i贾小林  阅读(214)  评论(0)    收藏  举报