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