国产高清在线免费观看-国产高清在线免费无码-国产高清在线男人的天堂-国产高清在线视频-国产高清在线视频精品视频-国产高清在线视频伊甸园

exec sp_renamedb 'olddbname','newdbname'

/*
    數據庫重命名
*/
Create procedure sp_renamedbnew
(
    @dbname varchar(30),
    @newdbname varchar(30)
)
as
    /* 清除數據庫的所有連接 */
    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