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
Where SRO_VT_ACCOUNT is your old databasename.
Maybe its usefull for some ppl here
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