Post reply

Which user is running the SP

  • October 13, 2009 at 5:39 am

    #73392

    I need to get the users loginame, who is running the SP from within the SP how you do you do that

    ie something like

    if @@user = 'user'

    print @@user

    Many thanks

  • October 13, 2009 at 7:16 am

    #1065171

    I only have access to version 2005 and 2008, so I don't know if the following code will work in the version you are using:

    SELECT nt_username

    FROM master.dbo.sysProcesses s

    WHERE s.spid = @@SPID

    BrainDonor

    Steve Hall
    Linkedin
    Blog Site

  • October 13, 2009 at 7:22 am

    #1065174

    Not sure if the query provided is the best way of doing it, but i can confirm that it works in sql 2000

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 13, 2009 at 10:46 am

    #1065299

    SELECT SYSTEM_USER

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply