Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

renamed ReportServerTEMPDB now errors referencing dbo.executioncache Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 8:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 7:58 AM
Points: 4, Visits: 18
Thanks for the solution,

Update 'the evil trigger' saved me a lot.
Post #1398427
Posted Thursday, January 24, 2013 4:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 2:24 AM
Points: 29, Visits: 27
hi, thank you very much. The solution saved me a lot of time. I had the same problem, but i have had to changed only the new temp db name in the mentioned trigger of the schedule table. All stored procedures had the right temp db name. Beforehand i configured the database over the Reporting Server Configuration tool again.
Many thanks again.
regards
Jürgen
Post #1411042
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse