SQLSERVER数据库管理员的专用连接DAC

select b.name as object,b.type,a.definition
    from sys.sql_modules a 
        inner join sys.objects b on b.object_id=a.object_id
        where b.create_date>=convert(date,getdate())
        order by b.object_id;






use  hwgasvip
go 
exec  sp_DecryptObject   F_decrypt
go;






USE master        
GO        
sp_configure 'show advanced options', 1 
GO    
sp_configure 'remote admin connections', 1 
GO        
RECONFIGURE WITH OVERRIDE    
GO




SELECT *  FROM sys.configurations where name = 'remote admin connections';














SELECT * FROM sys.dm_tran_locks
  SELECT * FROM sys.dm_os_memory_cache_counters
  SELECT * FROM sys.dm_exec_requests 
  SELECT * FROM sys.dm_exec_sessions