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

    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


  2. #2
    Join Date
    Feb 2004
    San Antonio, TX
    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 16: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