Results 1 to 2 of 2

Thread: dbcc checktable

  1. 02-01-2000, 10:15 AM #1
    Dave Nadeau Guest

    dbcc checktable

    Does anyone know the correct syntax for the dbcc checktable command? I am trying to fix a table index and have tried lots of combinations. Currently:
    dbcc checktable('tblrequestmaterials', index_id, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS

    It gives me an uspecific syntax error. Thanks Dave
    Reply With Quote Reply With Quote
  2. 02-01-2000, 10:42 AM #2
    Ray Miao Guest

    dbcc checktable (reply)

    SQL6.5 doesn't use 'with all_errormsgd'.


    ------------
    Dave Nadeau at 2/1/00 10:15:12 AM

    Does anyone know the correct syntax for the dbcc checktable command? I am trying to fix a table index and have tried lots of combinations. Currently:
    dbcc checktable('tblrequestmaterials', index_id, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS

    It gives me an uspecific syntax error. Thanks Dave
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules