Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: Error on copying the database

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sounds like a user defined function...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    it is, and it's there. Why would I get this error?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    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?

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How often do you back up the databases?

    Why not attach them...

    Would be the fastest thing to do....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •