Viewing post 1 (of 1 total)
For SQL Server 2005,I also think you need to exclude the predefined database users,dbo and sys.The query needs to be modified as follows:
select u.name from master..syslogins l right join sysusers...
July 5, 2007 at 9:40 am
#717440