Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Add a means to retrieve the call stack inside a stored procedure

There are many situations you would like to retrieve the call stack from inside a stored procedure. The most typical case may be a logging procedure where you want to know the exact way you ended up making this log entry.

There are also situations when you want to know the caller in a module to take some action. For instance, in a trigger you may want to permit some action only if it is performed from inside a stored procedure, which you assume know what it is doing. Another example is when you break up a stored procedure in two, and you want to make sure that the sub-procedure can only be called from the main procedure. That is, in the sub-procedure you would barf if the caller is anything else.

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Bob Sovers commented  ·   ·  Flag as inappropriate

        This appears to be a duplicate of "Provide function to retrieve the entire call stack"

      Feedback and Knowledge Base