CHANGE database name

[Maddona]

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

[​Exo]

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%'