Best way/product to handle database renames in sp's

[timscronin]

My developers have an application using 3 databases called
mardemo,mardemowh,mararchive. However when the solution is deployed to the user the db's name will be changed per client. Since several sp.'s have joins and other processes that use the dbname, they have to be changed for each client. Currently it is a manual update. Is there a better solution anyone knows up that will not affect performance?

 

[mrdenny]

Nope.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[vbkris]

>> However when the solution is deployed to the user the db's name will be changed per client.

the only way you could solve this is in the deployment process. how exactly do you deploy your SPs???

Known is handfull, Unknown is worldfull