Results 1 to 2 of 2

Thread: About SQL Login

  1. #1
    Join Date
    Oct 2003
    Location
    Cape Town
    Posts
    38

    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 ?
    Benone

  2. #2
    Join Date
    Jun 2004
    Posts
    57

    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
  •