Maybe usefull query for ppl that renamed there database

Cyberninjah

Newbie Spellweaver
Joined
Nov 16, 2008
Messages
29
Reaction score
4
Because some ppl changed there database name its possible that some stored procedures are not working anymore.

To find out what procedure is still using the old database name you can use this small query

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

Where SRO_VT_ACCOUNT is your old databasename.


Maybe its usefull for some ppl here
 
You must log in or register to reply here.