What is the definition of dbo_school?
Check its properties and see which server/database/table (or view) it is pointing to. Then on the source database server, check access permission on database...

As the author implied, SSRS is an overkill for simple HTML reports like this. However, if the intended tasks were simple, I prefer a self-contained XML method where I can...

I had some Access users who were downloading the entire 120 million rows from a table just to get 100+ rows of data out of it. They did everything right -...

When you assign a substring of a binary value to a varchar variable, you may not be getting what you expect. In this case, col2 and col3 are NOT NULL....

I suggest that you find a different way to manage the monitoring task.

For instance, try to do a select against the database first and capture any exception,...

Try this article by Jason Brimhall. I have an automated job based on Jason's code but it's mutilated beyond recognition. I cannot share it here as it infringes his rights.

You may wish to convert the word doc to PDF. I'm terribly worried about openning word docs on my pc.

SPID <=50 are mostly system processes and usually the program_name column should show blank. What was the program name for SPID24?

Sky-diving, anyone?

When I did my monitoring tasks with Powershell, I relied on LogParser.exe from Microsoft. It was an amazing piece of s/w with just one exe file. It marks the line...

I came from an environment where each customer has different and evolving customization needs. The application was designed in such a way that each customer can demand their own mix...