Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: dbcc checkcatalog

    After loading the database and executing the command

    dbcc checkcatalog(db_name)

    we get following error


    2550 is reported by dbcc checkcatalog and indicates a missing segment in sysusages segmap.

    Here my question is
    How to find find out
    Missing segment in sysusages segmap?

    This is very urgent for me.


    Thanks in Advance.

    Regards
    sR

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    The 1st lstart for each db should be 0
    The next should be lstart+size
    select lstart+size,* from sysusages order by dbid,lstart
    Did you manually dele from sysusages?

Posting Permissions

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