Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sudip678
Starting Member
3 Posts |
 Posted - 2008-07-21 : 05:54:48
|
| Hi,I am using SQL Server 2005. One of my SP's(SPParent) is calling another SP(SPChild). I would like to know the name of SPParent in SPChild at runtime. I do not want to pass any variable from Parent to child. Is there any way to do this?ThanksSudip. |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-21 : 06:21:51
|
| Check with sql profiler. |
 |
|
|
sudip678
Starting Member
3 Posts |
Posted - 2008-07-21 : 06:36:59
|
I need the info for logging purpose. Profiler wont be of use to me here.quote:
Originally posted by VGuyz
Check with sql profiler.
|
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-07-21 : 18:22:56
|
| I don't know of any mechanism to do this in SQL. The closest I have seen is the @@NESTLEVEL, which isn't what you want. |
|
|
|
|
|
|
Find the name of calling SP in the Called SP