Oh ya, It is important to add that 4 or 5 ASP pages that retrieve "FOR XML" data from sql all broke at the same time. So that would strongly suggest that either something was reset when I restarted SQL or a dependency was removed when I uninstalled the server monitoring software.

Trouble is I have no idea where to start to figure it out...I guess I could re-intall opManager and see....