Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    33

    Unanswered: user id into table

    Hi,
    I have a very simple question.
    Im running SQL code within and ASP (IIS) Web page.
    Im trying to insert into a table several variables from the Web page.
    In addition I want to get the system date/time and the user logon (DOMAIN).
    The statement is:
    Insert into T1
    (R1,R2,R3)
    Values
    (::V1::, getdate(), User_ID)

    The getdate() works fine, but how can I get the userID (Domain\Userid)


    Thanks

  2. #2
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    53

    Re: user id into table

    Hi,

    i think suser_sname() is the one you are looking for...

  3. #3
    Join Date
    Nov 2002
    Posts
    33
    Thanks,
    That worked

Posting Permissions

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