As a double check, I actually logged into SSMS as the ReportService account, and ran this T-SQL manually, and it worked. But the same code still fails when wrapped in...

Thank you Sue,

I checked and I did actually need to add some permissions to the ReportService account. Unfortunately I'm getting the same error though. I logged on as...

I needed a similar solution. I liked Lowell's clever use of the STUFF function (thanks). The problem I had, as mentioned above, is that multi and single line comments can...