corruption - SQL Server Forums

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

corruption

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-12-17 : 10:27:47

I tried to paste the whole file but didn't work. So here is a small part of it. Anyone know how i could solve it. Thanks

v 16, State 1, Line 1 : DBCC results for 'SW_DS_FINAL_SUM'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 15 rows in 1 pages for object "SW_DS_FINAL_SUM". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'BOM_Active_Sku_DV_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 12610 rows in 789 pages for object "BOM_Active_Sku_DV_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_city'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 3 pages for object "ml_city". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Monthly_SalesReps_2006_2007_SalesReps_List'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 546 rows in 15 pages for object "Monthly_SalesReps_2006_2007_SalesReps_List". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_2008_IPG_Comp_Program_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 9 rows in 1 pages for object "ADHOC_2008_IPG_Comp_Program_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'swidziun.TEMPCDVAR'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 21 rows in 1 pages for object "swidziun.TEMPCDVAR". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Adhoc_Dom_April_July'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 30522 rows in 3393 pages for object "Adhoc_Dom_April_July". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_QTD_FLEX'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 13 rows in 1 pages for object "SW_DS_QTD_FLEX". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'cr_parent_top10'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "cr_parent_top10". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'laugusti.Sheet1$'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 518 rows in 2 pages for object "laugusti.Sheet1$". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'LUC_Top20_Step3'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 29412 rows in 898 pages for object "LUC_Top20_Step3". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_STRETCH_2007_DOM_DATA_REPORT'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 844 rows in 21 pages for object "ADHOC_STRETCH_2007_DOM_DATA_REPORT". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'WEEKLY_SUBCLASS_BF_LQ'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 5610 rows in 99 pages for object "WEEKLY_SUBCLASS_BF_LQ". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_city_final'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 8 pages for object "ML_city_final". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_ORDERS_2007'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 299291 rows in 5173 pages for object "ML_ORDERS_2007". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_xpdex_user_name'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 97 pages for object "ml_xpdex_user_name". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_BOOKED_ORDERS'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "SW_DS_BOOKED_ORDERS". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC res

http://www.sqlserverstudy.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 13:09:42

Which dbcc command did you run? Didn't see any error in your post.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-12-17 : 14:30:12

try pasting it in

block

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-12-18 : 10:04:51

it doesnt let me paste it. its too big.

http://www.sqlserverstudy.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-12-18 : 21:19:05

where can i paste it?

http://www.sqlserverstudy.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources