Stored procedure not getting updated

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 1

[font="Verdana"]Do one thing, first comment all the mail shooting sp's which are working fine except the faulty sp and try to dig around it.

Also let us know, can't you write a SSIS package where you can put all your sp's there with container so that you will get exact problem.

anyways, let us know in more details, what exact the problem you are facing, like any error your final sp is throwing or any unexpected behavior?

Thanks,

Mahesh[/font]

MH-09-AM-8694

Mike01 SSChampion Points: 11420 More actions · Answer 2

If you run this code manually, does it do what you expect it to do?

exec ril_actuals_exceeding_budget_mail

if not, can you provide the code for that?

what shows up in RIL_Mail_Execution_report values table? Is this part of a transaction that might be getting rolled back? How is this called?

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/