12 2019 档案

摘要：SELECT DB_NAME(database_id) AS [Database Name],[Name] AS [LogicalName],[Physical_Name] AS[Physical Name],((size *8) / 1024) AS [Size(MB)],[differential_base_time] AS[Differential Base Time]FROM sys.ma... 阅读全文

摘要：增加端口映射，将10.10.10.10的11111映射到10.10.10.11的80端口 netsh interface portproxy add v4tov4 listenport=11111 listenaddress=10.10.10.10 connectport=80 connectaddress=10.10.10.11删除端口映射 netsh interface portproxy d... 阅读全文

摘要：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 阅读全文