Home > database >  SQL server 2008 login how to query the history records, such as which IP address database login
SQL server 2008 login how to query the history records, such as which IP address database login

Time:11-24

As the topic for old buddy help solve

CodePudding user response:

by
This you can try
SELECT the S.S PID, S.L OGINAME, S.L OGIN_TIME, S.L AST_BATCH, Arthur c. LIENT_NET_ADDRESS
The FROM sys. Sysprocesses S sys. Dm_exec_connections C
WHERE S.s c.s. ESSION_ID pid=

Original: https://blog.csdn.net/iteye_9077/article/details/82607951
  • Related