Post reply

How to read / check which server / machine is calling the stored procedure

  • January 25, 2010 at 6:54 pm

    #142011

    We have multiple application servers hitting the same stored procedure. I want to check in the stored procedure which application server is calling that stored procedure and business logic varies accordingly. How to check that. Please help

  • January 26, 2010 at 5:05 am

    #1108569

    I'm not sure you can do that - could be wrong and have been before - think I would be looking to get the application name passed into the stored procedure as a parameter by the app itself...

  • January 26, 2010 at 5:12 am

    #1108571

    doh !!! brain not woken up properly today...

    should be able to use

    select host_name()

  • January 28, 2010 at 1:06 pm

    #1110324

    Thankyou, sir. It helped.

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

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