Home Forums SQL Server 2005 Administering xp_cmdshell RE: xp_cmdshell

  • July 6, 2010 at 7:14 am

    #1189096

    river i am sorry; you are correct...if there is an error, NO_INFOMSGS returns them;

    here's the results you asked for...4 lines referencing jsut the single table that has the issue...the other 1000 + tables are ignored.

    dbcc checkdb with NO_INFOMSGS

    --results

    Msg 2508, Level 16, State 3, Line 1

    The In-row data RSVD page count for object "GMCDBGACCOMP_OLD", index ID 1, partition ID 377040118808576, alloc unit ID 377040118808576 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.CHECKDB found 0 allocation errors and 1 consistency errors in table 'GMCDBGACCOMP_OLD' (object ID 1458208345).

    CHECKDB found 0 allocation errors and 1 consistency errors in database 'AZ_900_TEST'.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!