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 |
|
seyha_moth
Yak Posting Veteran
74 Posts |
 Posted - 2007-09-21 : 04:33:25
|
| Dear sir/madamI have a problem related to trigger with parameter.I want to create trigger that fire when user delete data in a table.However,I am using asp.net to delete data in a tableA and insert deleted data to talbeB with storing UserDelete and DateDeleted.I look forward to hearing from you.Thank you in advance.Best regard,seyha moth |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-21 : 04:41:03
|
| You can't have trigger with parameters. You will have to handle this from the SP where you are performing DELETE operation.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
seyha_moth
Yak Posting Veteran
74 Posts |
Posted - 2007-09-21 : 04:52:13
|
| Thank you for your reply.seyha moth |
|
|
|
|
|
|
Trigger with parameter