Stored procedure

Question

Post reply

Stored procedure

moosamca

Right there with Babe

Points: 773
More actions
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.

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

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

Sergiy SSC Guru Points: 110208 More actions · Answer 1

OBJECT_NAME(@@SPID)

_____________
Code for TallyGenerator

Lowell SSC Guru Points: 323518 More actions · Answer 2

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!

Sergiy SSC Guru Points: 110208 More actions · Answer 3

Sorry, being brain dead.

_____________
Code for TallyGenerator

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 4

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"

moosamca Right there with Babe Points: 773 More actions · Answer 5

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

Anurag-428305 SSC-Addicted Points: 489 More actions · Answer 6

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

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 7

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"