I have actually created a table that list all jobs and schedules that are scheduled during the outage window and we are prioritizing them, talking to business owners to understand...

OK, I trust your GURU status 🙂  I was hoping it the job could be run, just without the updating of MSDB tables.  Guess it manually from my laptop instead....

And to add to the warnings about sp_msforeachdb or sp_msforeachtable, if you work with silly people that have used Reserved Names for objects, well... you can guess the rest.

JSC

Frederico, thanks for the quick response.  Unfortunately, I work for a company that is highly regulated by the state as we provide Medicare & Medicaid.  Therefore installing Office products on...

Thanks Phil.  Looks like that is going to be the best option for this project.  Disappointing that MS doesn't allow setting that property for the task.  I appreciate your suggestion.

Scott

The process I find most rewarding (but the most painful) is documentation. If I keep a running diary of what I am doing and re-read it along the way,...

I am receiving the same error (Error loading 'Package.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors...

OK, this can be closed now. Thanks to all for your input. I finally reversed the Grade and Course tables in the joins and got my answer. ...

OK, here is the an example with table names and obvious foreign key relationships. It contains data and the query I really need to fix. I am still...

Thanks all for the responses. Let me take a moment to say, I posted a generic example with "absurd" naming to give folks a feel for the data without...

Thanks for the response. This database receives information from many different and very dirty sources. I hear ya on normalization. Each student is a one-off so it...