While it may be a "bad practice" (and agree with all that others have said), any critically important queries that I need to run against production (say a hot fix/patch...

I find the easiest way to set up permissions in SSRS is to write it down on a blank sheet of paper first...it's so much easier to visually map it...

This isn't what I meant. This is the maintenance plan's "auto-generated" code.

Try opening SSMS, on the server this all runs on expand the (+) for the SQL Server Agent,...

Permissions in SSRS are tedious, but can be easily set. The things to remember is the security structure in inherited....so what is set at the "top" level is granted...

Is selecting the text, copying it into notepad, then saving it as an RDL file not an option or is your sole purpose to "automate" it?

Script out the jobs you are having issues with and post them here. There has to be some TSQL script sending the email...

So under the Agent "Notifications" tab, do you have "Email" checked, the appropriate "Operator" selected, and "When the job fails" selected? or are you doing everything via TSQL?

But you've never mentioned sending a report or a file via email, only that people were receiving emails in both cases when the result was good/bad.

So, it sounds like you...

+1 , anyone live in the Nashville, TN area???

No worries, we are all here to learn 🙂

If this is the case, can you confirm that in the Precedence Constraint Editor, that you have the Evaluation Operation set to...

+1 to bench-marking, hard to tell what is what without knowing your basic daily load. I would recommend using PerMon or a similar tool to perhaps tally up some...

What we can ALL AGREE upon is whichever route you take, please DO NOT SKIP STEP #10

You should set up transaction log backups to run "frequently". How frequently would depend on the type of system you have running and what level of point-in-time recovery option you...

Quick update. Use varchar(max), not nvarchar(max).

This will detect any change within each string

You could tweak the script [Click Here][/url] to script out and store your indexes to a centralized table, then use a simple check to compare them (this is what I...