查询最新修改的SP及远程登陆的用户,和断掉

select [name] from sys.all_objects where type = 'p' and modify_date  > '2007-11-6'
exec master.dbo.xp_cmdshell  'logoff id '
exec master.dbo.xp_cmdshell  'query user'

转载于:https://www.cnblogs.com/ZhengGuoQing/archive/2008/01/10/1033281.html