22,209
社区成员
发帖
与我相关
我的任务
分享
use master
go
create table database_demo.dbo.loginer
(id int,name nchar(256),logintime datetime)
go
create trigger login_triggers
on all server with execute as 'WIN-OOMO6SBJSUM\Administrator'
for logon
as
begin
insert into database_demo.dbo.loginer(id,name,logintime)
select session_id,original_login_name,login_time
from sys.dm_exec_sessions
where original_login_name='WIN-OOMO6SBJSUM\Administrator'
commit
End