Post reply

Database not in sysobjects

  • December 19, 2005 at 8:15 am

    #167394

    I move my database files to another drive via the detach db, move file, attach db method.  Now when I try to run dbcc dbreindex it complains my database is not in sysobjects!  Otherwise, everything is working correctly.  How do I get it back in sysobjects so I can run the dbcc utilities that depend on it being there?

    Thanks for any help

  • December 19, 2005 at 9:29 am

    #610354

    First thing I would try would be to run SP_UPDATESTATS on the database you just attached.

  • December 19, 2005 at 9:46 am

    #610359

    The statistics updated without a hitch (and ran much faster than the last time with the old disk configuration, woo-hoo!) but dbcc dbreindex still says it isn't in sysobjects.

    Thanks; any other suggestions?

  • December 19, 2005 at 10:03 am

    #610368

    Oops, nevermind, the detach and reattach changed the owner and I didn't notice.  Got it going now.  Thanks anyway!  Doh!  >slap self<

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply