sp name in trigger

Hot Topic

Selecting Connection in Custom Destination Component UI
Upsize Access 2000
Implementing SQL Server 2005 DR solution with database mirroring
Datatype conversion strangeness
Restricting number of records
Visual Studio Command Prompt
Data Flow Task SQL strings
More SSIS via the web
Beginning SSIS - Sharepoint and Excel
Data Transfer reported as succesfull BUT only one row is ever transfered!!

SQL Server

Date Time Format Options When Writing to a Flat File
Data Flow Source for dbf (DBASE IV) files
How do I install SQL Enterprise Manager?
Visual Web Developer 2005 Express -- with SQL Server Developer 2005?
Integration Help
Problem: Deployment works, but processing does not
can't get the complete list of tables owned by the dbo
asp.net confgiguration tool. tool keeps timing out
MSSQL 2005: MSSQL service automatically 'stop' after launch Management studio
AdventureWorks Sample Reports

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

  • scotsman60

    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.

  • Mikael Gosen

    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