name of the calling stored proc from within a trigger

How do you get it from the system?
Thanks in advance,
Koni.Hi
You can't. It is not available as it might have been T-SQL, a SP, or a
Trigger that caused the modification.
Best you can do is a DBCC INPUTBUFFER(spid) to find out what was executed
(portions of the text)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Koni Kogan" wrote:

> How do you get it from the system?
> Thanks in advance,
> Koni.
>|||See if this helps:
http://vyaskn.tripod.com/tracking_s...by_triggers.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Koni Kogan" <kkogan@.haiint.com> wrote in message
news:OyjzomLUFHA.3344@.TK2MSFTNGP10.phx.gbl...
How do you get it from the system?
Thanks in advance,
Koni.|||Narayana Vyas Kondreddi wrote:

> See if this helps:
> http://vyaskn.tripod.com/tracking_s...by_triggers.htm
Cool! I think this is exactly what I was looking for.
Thanks!

MY SQL trigger(PK generation problem)

hi all,
i have a good knowledge of Oracle but quite new to Ms-SQL, i want to create PK generation trigger in MS-SQL

Will somebody help me?

Thanks in Advance

MadhaviHeya, Madhavi. Welcome to TSDN!

I'm going to go ahead and move this thread to the MSSQL forum, where our resident Experts will be better able to help you out.