Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Server: Msg 2537, Level 16, State 43, Line 1

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts
Posted - 2007-08-25 : 15:37:33
i have sp4 install. Anyone know how to fix it?

Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 1376776012, index ID 0, page (1:56868), row 2. Record check (Valid SqlVariant) failed. Values are 7 and 0.
Server: Msg 2537, Level 16, State 1, Line 1 ... so on

=============================
http://www.sqlserverstudy.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-08-25 : 16:07:08
When do you get this error?


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts
Posted - 2007-08-26 : 15:57:37
after running "dbcc checkdb"

=============================
http://www.sqlserverstudy.com
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts
Posted - 2007-08-26 : 17:14:27
Can you post the full results of the checkdb please?

Paul Randal
Managing Director, SQLskills.com
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts
Posted - 2007-08-27 : 11:56:11
im getting a http 500 error when i try to paste the full result.

=============================
http://www.sqlserverstudy.com
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts
Posted - 2007-08-27 : 20:00:26
Sorry - I can't help you interpret the results unless I can see them all. Can you put them on a website somewhere and post a link?

Paul Randal
Managing Director, SQLskills.com
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts
Posted - 2007-09-07 : 11:32:38
Msg 2536, Sev 16: DBCC results for 'CLAIMS_AUDIT_TRAIL'. [SQLSTATE 01000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446296), row 41. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446296), row 59. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446296), row 59. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 88. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 88. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 105. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 105. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 114. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446297), row 114. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 17. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 17. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 62. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 62. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 83. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 83. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 118. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 118. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 135. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446299), row 135. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446300), row 107. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446300), row 107. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 11. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 11. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 116. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446301), row 116. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 17. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 17. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 21. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 21. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 23. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 23. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 44. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 44. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 47. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 47. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 50. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 50. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 53. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 53. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 64. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 64. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 67. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 67. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 70. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 70. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 91. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 91. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 107. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446302), row 107. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 1. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 1. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 27. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 27. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 76. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 76. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 115. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446303), row 115. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446304), row 15. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446304), row 15. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446304), row 120. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446304), row 120. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446305), row 40. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446305), row 40. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446305), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446305), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 26. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 26. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 48. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 48. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 65. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 65. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 82. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 82. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 96. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 96. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 103. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 103. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 110. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 110. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 114. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 114. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 117. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 117. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 123. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446306), row 123. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 0. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 0. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 67. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 67. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 75. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 75. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446307), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 6. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 6. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 20. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 20. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 38. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446308), row 38. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 5. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 5. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 13. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 13. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 38. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 38. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 84. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446309), row 84. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446311), row 63. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446311), row 63. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446311), row 76. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446311), row 76. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 106. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 106. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 131. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 131. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 144. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 144. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 146. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 146. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 151. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446312), row 151. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 10. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 10. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 17. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 17. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 151. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446313), row 151. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 36. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 36. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 43. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 43. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 55. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 68. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 68. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 100. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 100. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 114. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446314), row 114. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446315), row 13. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446315), row 13. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446315), row 84. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446315), row 84. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 44. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 44. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 68. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 68. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 105. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446316), row 105. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 21. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 21. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 70. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 70. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 87. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 87. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446317), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 71. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 71. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 79. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 79. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 89. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 89. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446318), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446319), row 52. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446319), row 52. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446320), row 91. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446320), row 91. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 55. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 64. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 64. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 75. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 75. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446321), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446322), row 35. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446322), row 35. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446322), row 101. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. [SQLSTATE 42000]
Msg 2537, Sev 16: Table error: Object ID 919442648, index ID 0, page (1:7446322), row 101. Record check (Valid SqlVariant) failed. Values are 6 and 0. [SQLSTATE 42000]
Msg 8986, Sev 16: Too many errors found (201) for object ID 919442648. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS". [SQLSTATE 42000]
There are 1239926 rows in 9727 pages for object 'CLAIMS_AUDIT_TRAIL'. [SQLSTATE 01000]
CHECKDB found 0 allocation errors and 59820 consistency errors in table 'CLAIMS_AUDIT_TRAIL' (object ID 919442648). [SQLSTATE 01000]

=============================
http://www.sqlserverstudy.com
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts
Posted - 2007-09-07 : 12:13:22
My guess would be you've hit the situation described here http://support.microsoft.com/kb/872842/


Paul Randal
Managing Director, SQLskills.com
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts
Posted - 2007-09-07 : 13:19:05
i have the latest SP4 installed.

=============================
http://www.sqlserverstudy.com
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts
Posted - 2007-09-07 : 13:39:45
ok - in that case I don't know - although it does look like something systemic with sqlvariant columns. You'll need to contact Product Support to help figure it out (http://support.microsoft.com/sql)

Thanks

Paul Randal
Managing Director, SQLskills.com
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site