狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

exec sp_renamedb 'olddbname','newdbname'

/*
    數(shù)據(jù)庫重命名
*/
Create procedure sp_renamedbnew
(
    @dbname varchar(30),
    @newdbname varchar(30)
)
as
    /* 清除數(shù)據(jù)庫的所有連接 */
    declare @spid int
    declare @sqlforclear nvarchar(100)

    declare curid cursor forward_only read_only for (select spid from master.dbo.sysprocesses where db_name(dbid)=@dbname)
    open curid
    fetch next from curid into @spid
    while @@fetch_status = 0
    begin
        set @sqlforclear = N'kill ' + cast(@spid as nvarchar(10))
        exec sp_executesql @sqlforclear
        --if @@error = 0 print 'clear:' + cast(@spid as nvarchar(10))
        fetch next from curid into @spid
    end
    close curid
    deallocate curid

    /* 重命名 */
    exec sp_renamedb @dbname,@newdbname
GO