Maybe usefull query for ppl that renamed there database

[Cyberninjah]

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

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

 

[MikroTekken]

Thanks Keep up

 

[RenePunik]

Was useful for me. thanks

 

[Pure3viL]

usefull