CHANGE database name

12/17/2015 08:00 Maddona#1

i want to change database name > example sro_vt_shard > sro_vt_shard_merazz
in producers ? too ? :confused:

12/17/2015 13:21 Exo#2

Code:

Make sure you are selecting the target database before executing this query!

--Results will be the SP names that contains your old database name.
##Manual change required!!

SELECT OBJECT_NAME(id) FROM syscomments WHERE TEXT LIKE '%OLD_DATABASE_NAME%'