- 博客(2)
- 资源 (7)
- 收藏
- 关注
原创 sqlserver 查看数据库连接情况
select t2.name as 数据库名,t3.client_net_address as ip地址, t1.host_name as 电脑名 from master.sys.dm_exec_sessions t1 inner join master.dbo.SYSDATABASES t2 on t1.database_id=t2.dbid inner join master.sys.dm_...
2018-05-11 13:26:19 8823 1
原创 限制MsSql Ip地址访问
ALTER TRIGGER [tr_connection_limit] ON ALL SERVER WITH EXECUTE AS 'sa' FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= 'sa' --允许sa在本机和下面的IP登录 AND (SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', ...
2018-05-11 11:24:36 1372
DHTML 手册.chm
2012-11-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人