This Blog is about MSSQL server 2000/2005 and 2008
Thursday, September 20, 2012
List of inactive users in a DB
SELECT u.*, l.* FROM sysusers U left outer join master..syslogins L on U.sid = L.sid where l.sid is null and u.altuid is null and u.status <> 4 and u.name not in ('sys','guest','INFORMATION_SCHEMA') order by u.name
No comments:
Post a Comment