sp name in trigger

Hot Topic

SQL Server 2005 CTE reports wont deploy...
SqlServer2005 can support merge replication with SqlCe2.0??
Uninstall utility error "ISCLUSTERED"
New SQL-NS 2005 Book
reset toolbox doesn't delete my components
Error locating server/instance specified
Server Name problem
Scalar Function with the field name and table name as paramater
How to avoid reload of parameter area in drillthrough report
What kind of data can I save in a SQL database?

SQL Server

Using connection managers inside custom log provider failing!
concatenate a string within a loop from a temp table
system error 126
Deploy Reporting service 2005
CLR Enabled
Return more than 4000 characters from CLR stored procedure
Context Class in AS 2005 Stored Procedure
Locking up after SQL Server Mobile Merge Replication
SQL express 2005 - can not set up a database why?
Welcome everyone

sp name in trigger

There are two different Stored Procedures insert data into a table, is it possible to catch what stored procedure name was that trigged the trigger in the trigger




Answer this question

sp name in trigger

  • Mr.Analogy

    You could use the SET CONTEXT_INFO command to store the SP name in a connection wide context and then retrieve it from the trigger using a query on sysprocesses or CONTEXT_INFO() built-in in SQL Server 2005. See BOL on SET CONTEXT_INFO for more details. This will allow you to perform the check without modifying the schema. If you are on older versions of SQL Server like 70/65 then you can store the name in a temporary table or global cursor in the SPs and then retrieve it from the trigger code.

  • Jane Stop This Crazy Thing

    Hi,

    you can pass the procname as a column as information to the table, then the triger can leep track of the source of change. Otherwise there is no way to get this information.

    HTH, Jens Suessmeyer.

    ----
    http://www.sqlserver2005.de
    ----
  • sp name in trigger
Answer this question