日期:2014-05-18  浏览次数:20327 次

查询登录数据库的用户信息?
想查询登录sqlserver数据库的用户信息,请问怎么查询?

------解决方案--------------------
SQL code

exec sp_who
/*
spid   ecid   status  loginame                                                                                                   hostname                   blk   dbname            cmd   
1      0      background                     sa                                                                                                                                                                                                         0     NULL                                                                                                                             LAZY WRITER     
2      0      sleeping                       sa                                                                                                                                                                                                                                                                0     NULL                                                                                                                             LOG WRITER      
3      0      background                     sa                                                                                                                                                                                                                                                                0     master                                                                                                                           SIGNAL HANDLER  
4      0      background                     sa                                                                                                                                                                                                                                                                0     NULL                                                                                                                             LOCK MONITOR    
5      0      background                     sa                                                                                                                                                                                                                                                                0     master                                                                                                                           TASK MANAGER    
6      0      background                     sa                                                                                                                                                                                                                                                                0     master                                                                                                                           TASK MANAGER    
7      0      sleeping                       sa                                                                                                                                                                                                                                                                0     NULL                                                                                                                             CHECKPOINT SLEEP
8      0      background                     sa                                                                                                                                                                                                                                                                0     master                                                                                                                           TASK MANAGER    
9      0      background                     sa