Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    51

    Question Unanswered: NTlogin user account to sql 2000

    is there a way to move login names or Win 2000 active directory to SQL?
    need to get NT login name, emp id to database so i can use for some other application and the way to automate update like in DTS

    THANKS

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    i'm not sure what you want but you can use system functions (as listed below) to discover that information

    BOOKS ONLINE{security functions}
    Books online---- USER_ID, SYSTEM_USER

    and you can also query the information_Schema. Views for this metadata as well.
    Last edited by Ruprect; 12-15-04 at 17:58.

Posting Permissions

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