Post reply

Stored procedure

  • April 10, 2007 at 12:27 pm

    #117994

    Is there any function in sql server to get the current stored procedure name.

    Context is I want to log the stored procedure name into a table once the procedure starts.

  • April 10, 2007 at 2:21 pm

    #699637

    OBJECT_NAME(@@SPID)

    _____________
    Code for TallyGenerator

  • April 10, 2007 at 7:40 pm

    #699671

    isn't it @@proc_id? so object_name(@@proc_id), rather than the @@spid?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 10, 2007 at 7:54 pm

    #699675

    Sorry, being brain dead.

    _____________
    Code for TallyGenerator

  • April 10, 2007 at 11:40 pm

    #699697

    And for SQL Server 2005, you have to drop the underscore

    SELECT OBJECT_NAME(@@procid)

     

     

    N 56°04'39.16"
    E 12°55'05.25"

  • April 11, 2007 at 3:52 am

    #699723

    Thanks. Thank you so much to all. It is working fine..

  • April 12, 2007 at 2:18 am

    #699974

    can any body tell me " How to create a procedure from two databases?"

  • April 12, 2007 at 2:24 am

    #699976

    You should start a new topic.

    But... One way is to use fully qualified names.

     

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 8 posts - 1 through 7 (of 7 total)

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