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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2006-06-16 : 07:42:23
|
| HiI have trigger,that trigger having Procedure(This procedure is ment for sending mails),if we insert data we have to send mails about 2000 mails,this is goal,mail sending is OK but at that my application getting slowcan some give me the Best solution on thisregardssreenivas |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-16 : 16:23:27
|
| Then why cant you try for Asynchronously send the mails.Solution1: Backend only Insert Record. From a batch job OR from front end write a piece of code to send emails async process. Solution2: My best bet is write a DTS job, it will check every 30 minutes to the table, if any new records found, it will send the mails.With RegardsBSR |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
How to control the trigger