Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Renaming The Reporting Services TempDB Database

Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to break. The main ReportDB (regardless of what you named it) has hard references to the location to the ReportingTempDB (whatever it was called when you did the install). I found this post from quite a while back and it’s still useful, but on SQL 2012 there is a function and two views that also need to be changed in addition to searching through all the stored procedures.

Comments

Leave a comment on the original post [sqlandy.com, opens in a new window]

Loading comments...