Hi,
I'm currently in the midst of writing my first sqlclr sproc.
In our normal T-SQL sprocs we use the following:
OBJECT_NAME(@.@.PROCID)
to get the name of the sproc. We later use the result of this as a parameter to a custom message when we use RAISERROR.
Question is, is there a way of doing the same from within a SQLCLR sproc? i.e. Can someone give me a bit of code that will return the name of the current sproc? (Obviously this is not the same as the name of the .Net class that implements my sproc).
Thanks in advance for any help that you can provide.
Regards
I've had word from Umachander at MSFT who says that this isn't possible but that they are looking at it for a future version.
-Jamie
No comments:
Post a Comment