Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628

    Unanswered: DBCC CHECKDB command help...

    I need a bit of a hand with coding the DBCC CHECKDB command in QA.

    I have been trying to configure my helpdesk database after moving drives in the original box after the old one ran out of space.

    Now when i try and start the server daemons, i get a database check error.

    can anyone help out with a DBCC CHECKDB command that will only check the database named AHDTEST50?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Assuming that you ae using SQL Server 2000, then I'd use:
    Code:
    USE AHDTEST50
    GO
    DBCC CHECKDB ('AHDTEST50') WITH ALL_ERRORMSGS
    GO
    -PatP

  3. #3
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    Pat to the rescue again!

    Thanks pat.

Posting Permissions

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