March 11, 2011 at 8:56 am
This question goes out to any one who can answer 🙂
I just want to know when we rename a database use either a alter method or a SSMS. what is the effect on the server of that ?
meaning lets say I change a database name on a production box..
what if we have SSIS packages running using the database name, I presume we have to change names in ssis there too.
Will it have an effect on the client/application side with the connection to this above mentioned database?
any insight is helpful
March 11, 2011 at 10:07 am
Yes, any reference to that database will have to be changed to the new name; whether in SSIS, query, connection string, etc. Best to log all connections to that database for a while and see where they are coming from and get a consolidated list before renaming.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply