Post reply

finding login in stored procedure

  • April 28, 2003 at 10:52 am

    #80082

    This should be simple if possible.

    I would like to find out the login from within a stored procedure.

    I would like to customize the data returned from the stored procedure based on the login.

    A simple case statement but what can I evaluate to find out the login.

    Thanks

    David Weil

  • April 28, 2003 at 11:09 am

    #455542

    You might try suser_sname()

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • April 28, 2003 at 4:41 pm

    #455603

    Thanks

    Worked like a charm

    David Weil

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

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