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 |
|
DMP
Starting Member
41 Posts |
 Posted - 2005-12-16 : 07:19:41
|
| Can i Call Stored procedureds from Trigger ?If Yes please explain advantage & Dis-advantage for this sort of developmentThanks |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-16 : 08:08:03
|
| Calling sp from trigger is inefficient if more data are inserted to the table and the called sp is complexMadhivananFailing to plan is Planning to fail |
 |
|
|
DMP
Starting Member
41 Posts |
Posted - 2005-12-16 : 08:11:31
|
| Thanks Surendra,I notice your reference URLBut Question remains open till now.Please Help......... |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-16 : 09:47:51
|
| I would advice you stick to your SP, it can do all you wantless disk utilization, faster, better and more efficient |
|
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-12-19 : 04:29:32
|
quote:
Originally posted by DMP
If Yes please explain advantage & Dis-advantage for this ....
It totally depend on how you are going to use this.... but be careful while doing any DML operations using sp on tables, otherwise it will call another trigger.I could not found any document/link which will explian the advantage and disadvantage.Surendra |
|
|
|
|
|
|
Stored Procedures from Trigger