• This query

    SELECT u.name

    FROM sys.server_principals u

    JOIN sys.server_role_members rm ON u.principal_id = rm.member_principal_id

    JOIN sys.server_principals r ON r.principal_id = rm.role_principal_id

    WHERE r.name = 'sysadmin'

    Will give you all members of sysadmin. If there are any server roles listed, you can unwind them the same way.

    What particularly comes to mind is that BUILTIN\Administrators may be there and the account is a administrator on the machine itself.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]