need info

  • i would like to find whether the login belongs to group or sql user \windows user in sql 2005\sql2008

  • Try this

    SELECT p.name,p.type_desc

    FROM sys.server_principals p

    WHERE p.type LIKE '[GUS]';

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply