vendredi 23 janvier 2015

Can I log which stored procedure issued a delete statement?


We have an issue where rows are deleted from a table and we can't figure out where this is happening. We have a trigger on the table to move the rows to another table, so that we can move the data back to the original table.


There are 20 to 30 stored procedures that delete rows from the table, so I was wondering if there was some way for the delete trigger to know what procedure invoked it.


We're using Sybase 15.


Thanks!





Aucun commentaire:

Enregistrer un commentaire