Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alhopkinson
Starting Member
1 Post |
 Posted - 2005-03-04 : 11:50:05
|
| Hi,I am trying to write a proc to look at the sysxlogins table to get a list of all users and the server roles assigned to them and record it for audit purposes. Does anyone know how i can exclude the logins for linked servers? Thanks |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-03-05 : 11:57:48
|
| select * from sysxlogins where COALESCE(srvid, 0) = 0ORselect * from sysxlogins where srvid IS NULLTim S |
 |
|
|
|
|
|
Auditing logins