Hi guys,
I can't find what is wrong.
I am copying a database via DTS and I get an error mid way "Invalid object dbo.fx_get_role_from_ownerid". But the object does exist and it has benn in production for a while now.
Why would I get his error, if the object does exist?Sounds like a user defined function...|||it is, and it's there. Why would I get this error?|||On the face of it...I'd say the stupid Object Id is out of whack with the object name...
try and recompile the function...then try it...
Why are you using DTS instead of dump and restore?|||Hi,
I have recompiled the function and still get the error.
I am using DTS to copy all databases on the server to another server every week automaticaly.
Any other ideas?|||How often do you back up the databases?
Why not attach them...
Would be the fastest thing to do...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment