Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Maybe usefull query for ppl that renamed there database

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 :)
 
Back
Top