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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-22 : 07:48:13
|
| Pushp writes "I want to log Trigger action in Log Table. Do the MS SQL server have any Varaible or some thing like that which returns the Trgger's Action on which the triggers fired i.e. Insert/Update/Delete.Although this can be implemented by logic like I can use conditions but I want some thing from SQL server which return the action of triggers." |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-03-22 : 15:52:41
|
| As I can say there is no such a feature in SQL Server. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-22 : 18:56:52
|
| Any logging of a trigger's action would need to be written in the trigger itself, and you'll know at the time it was created what actions it can perform. |
|
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2005-03-23 : 01:28:44
|
| I agree.If this feature is there in SQL Server itself,it would be more helpful in many ways.:) While we stop to think, we often miss our opportunity :) |
|
|
|
|
|
|
How to find Triggers Action