查询sql server 用户登录记录

SELECT (sd.Name)'数据库',loginame,sp.* FROM 
[Master].[dbo].[SYSPROCESSES] sp,[Master].[dbo].[SYSDATABASES] sd
order by login_time desc

select Session_id as spid, connect_time,client_net_address '客户端IP',local_net_address '服务器的IP' from sys.dm_exec_connections
order by connect_time

 select a.session_id,login_time,login_name,host_name,program_name,status,connect_time,client_net_address '客户端IP',local_net_address '服务器的IP'
 from Sys.dm_exec_Sessions a 
 left join sys.dm_exec_connections b on a.session_id=b.session_id
 order by connect_time desc