In my case the report server account already had RSExecRole in all relevant databases. Grant exec on procdure to role in master database helped:

use [master]

GO

GRANT EXECUTE ON [sys].[xp_sqlagent_notify] TO [RSExecRole]

GO

I have experienced problems with tables containing LOB_DATA where non of the below statements had any effect in respect of releasing unused LOB_DATA pages.

alter table ... rebuild

alter index ... rebuild

alter...

Hi

I have been struggling with this error for month and tried almost every googable hint.

Finally found out the the error in my case was related to an old version of...

I have experienced the same problem in a SharePoint _SharedServices1_Search_DB with the stored procedure proc_MSS_GetCrawlHistory. It was running for >120 seconds, 100% cpu on a 4 CPU machine.

I'm convinced that...