It's already been explained in the first reply to the original post. Please read this post in the thread:

https://www.sqlservercentral.com/forums/topic/using-a-temporary-table-in-ssrs#post-1993987

Sue

I would try with another higher version of SSMS and see if you still have the same issue. Just seems there are many weird bugs with different versions of SSMS...

Very well done article -  can get folks going down the right path with all the formatting options. Thanks for taking the time to write that!

Sue

Getting dumps now and still getting them a year later? You should open a case with Microsoft. And it took 9 months to download the tool? You can open those...

Try adding the module_end event to your event session. I believe you need to include that to get the parameters.

Sue

How you go about it may depend upon how much data you have in the table or some other details we don't know about. You'd just have to play around...

Monitoring tools are a great purchase - I agree with what Brian wrote. But if that's not a possibility, Are you responsible for the entire server or just SQL Server?...

You can try increasing it as it often helps in a situation like yours. You have to play around with what to set it to but increasing it to 50000...

Since you ran DBCC CHECKDB on all of the databases and also tried the backup using t-sql, I would check the windows logs for errors around the same time as...

I very highly doubt it and not aware of any such thing. That would certainly break a lot of systems if that could happen. No one may remember doing it...

I've seen that question posed to Microsoft before and they indicated there was no limit on the number of folders. But in your case and with nesting them, I would...

There is a new DMV added for this with 2019. And it's not listed. So that new DMV should be the correct answer and the question wouldn't have had to...

You use the web portal URL to connect to the portal or to use Report Builder, not the web services URL.

Sue

Make sure the URLs are configured, check the URLs in Reporting Services Configuration Manager and then Check the SSRS trace log for errors when you are trying to connect.

Sue

The error is on the internal database snapshot used by dbcc checkdb.  The snapshots use sparse files but those can get large if this is a decent sized clarity database...