But, at the first time you must create the Trigger by using the "inserted" table. The "inserted" table is a built-in table every update-or-insert trigger uses. In the INSERT...

....I'm using SendMail task with a MS Outlook profile (for your information)

Thanks & Regards

Jorge

Peter, thanks for your suggestions... But i'm not quite sure it works as you said...When I manually sends mails (with attach files) using MS Outlook it works fine: at destination...

Hi... yes i ran it from QA using xp_cmdshell..... It still hangs... never finishes 🙁

Thanks....

Jorge

Every time you uses transactions you must be aware of two issues: 1) Transactions could increase the number of locks and resources 2) Right handling of nested transactions. Furthermore...

Hi, I don't know if this help you... but instead of T-SQL you can build a DTS with the sp call as the input of the Data Transfer and 'account_name'...

Hi,

Use the UPDATE STATISTICS (table_name) to update the statistics. Cause the query plan is based on these statistics. In the result set try to use the same fields...

I see table's & indexe's structures are both the same in test server and production server... but are you sure data is the same on the two environments?. A...

Thanks for your comments. Let's talk a little about our work: We are converting and loading data from a legacy System to SAP. We are talking (in some...

To Julian: First of all, thanks for your comments. Finally, I had to do something similar: First I started the sql server with command line -c -f, then I...

A question: changing trace flag 3608 skips recovery only while trace flag is ON (I think: YES)? but I'd like DEFINITIVELY abort the recovery process (at any switch value of...