Re: Admin users on SQL Server

From: John (john_w_john2001NOSPAMNOSPAM@yahoo.com)
Date: 07/23/02 

From: "John" <john_w_john2001NOSPAMNOSPAM@yahoo.com>
Date: Tue, 23 Jul 2002 15:38:40 +0530

xp_Logininfo just returns the admins in master. Barry's script iterates
thro' all DB and thats what I was looking for.

"Suresh Channamraju" <sureshvc@online.microsoft.com> wrote in message
news:GTjKH4hMCHA.6720@cpmsftngxa07...
> Run from SQL Query Analyser,
> xp_logininfo
>
> Check the privilege column.
>
> Regards,
> Suresh.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
>
>