mmm

We have seen poor performance with EXCEPT on large data sets.

Used as is, this didnt work for me on SQL2005.

Invalid column name 'dtproperties'.

Edited the proc to remove all " marks and replaced them with the proper ' marks.

Doesnt seem to work with SQL2005? Breaks at referencing the "name" column of sysjobschedules since that column doesnt exist.

Yes, I liked your writing style, but really you can only use RAISEERROR, otherwise you're going to confuse the heck out of your users like you mentioned.

In my case removing the SQL Instance name fromt he Report Server URL solved the issue.

Make: http://localhost/ReportServer instead of http://localhost/ReportServer$SQLINSTANCE

Thank you so much.

It's great topic!!!!:-D