script to find valid users

Last Post 02 Jul 2008 06:23 AM by ufohj. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 May 2008 08:45 AM
ANyone seen a script to validate nt/sql users. In our 3rd party app the individual user is added as a login. But during time these people may leave. Trying to validate the users who no longer are valid (we do use AD)
New Member
New Member

02 Jul 2008 06:23 AM
Same issue bothers me.
Sometime Network Dept. just dropped the AD logins without telling us.
New Member
New Member

17 Jul 2008 10:04 AM
Related to this issue, I apparently have orphaned Windows GROUP level logins SQL Server for which the windows account is gone. When I exec xp_logininfo for these accounts, I get:

exec master..xp_logininfo 'DOMAIN\groupname','members'

Server: Msg 8198, Level 16, State 12, Procedure xp_logininfo, Line 38
Could not obtain information about Windows NT group/user 'DOMAIN\GROUPLOGIN'.
and the script fails.

Anybody know how I can trap this error and not abort the script?

Acceptable Use Policy