[Question]Query to Change DB Names

03/17/2015 11:45 MissinGDeaTh#1

i want a query to change DB Names completely in procuders too with out having any problems. any one can help me please ?

03/17/2015 12:43 Exo#2

Generate a script for that DB and replace the names.

03/17/2015 12:54 Crue*#3

PHP Code:


			
SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%SRO_VT_ACCOUNT%'