[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Get the SP name from inside the SP?

From a stored procedure's TSQL ... is it possible to get the NAME of the stored procedure being executed?

Fred
0
volking
Asked:
volking
1 Solution
 
HainKurtSr. System AnalystCommented:
use

select object_name(@@procid)
0
 
volkingAuthor Commented:
Works perfectly!
Thank you!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now