Results 1 to 2 of 2

Thread: About SQL Login

  1. #1
    Join Date
    Oct 2003
    Cape Town

    Unanswered: About SQL Login

    Hi all

    Does someone know a strored procedure or any t-sql that lets you know wheter a login is windows or sql authentication ?

  2. #2
    Join Date
    Jun 2004

    sysusers for users and syslogins for logins

    You can query the following tables:
    sysusers for users and syslogins for logins.
    You will find columns like issqluser or issqluser.
    This columns will inform you if the user (login) is windows or sql user (login).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts