摘要： ALTER proc [dbo].[SYS_查询当前执行SQL语句] as begin SELECT [Spid] = session_Id , ecid , [Database] = DB_NAME(sp.dbid) , [User] = nt_username , [Status] = er.s 阅读全文

摘要： ALTER PROC [dbo].[SYS_DB_KillConnections] ( @dbname VARCHAR(200) ) AS DECLARE @sql NVARCHAR(500) DECLARE @spid NVARCHAR(20) DECLARE #tb CURSOR FOR SEL 阅读全文

摘要： ALTER proc [dbo].[SYS_DB_Delete_Log] ( @DBName varchar(50) ) as -- 删除数据库日志 --Create by HDL 20141217 -- 用于将数据库日志文件删除重新创建 -- SYS_DB_Delete_Log 'ImportDB 阅读全文