• There is a small bug in the new version of this stored procedure which I sent to this web site. When using the sysxlogins table login names can be in the table multiple times. I left of a WHERE clause on the sub-queries which will only pull names from the local server. See my website for correction details.

    Randy