I have a SQL Server 2000 database that had its data corrupted. Any text field, usually varchar(50) or greater, had most of its text replaced with a script HTML tag pointing to a w.js file on rnmb.net. I think the update came in through a website because only one of the databases on the server had its data corrupted. Has anyone heard of this before? I can't find any information on this corruption on the internet because when I do a search for the exact script, it returns other websites that have been corrupted by it.
Greetings to all - I am trying to enter the date fields from my form into a SQL 2005 db by way of Visual Basic. The VB parameters are as follows: Protected Sub DataEntry_Btn_NewGig_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataEntry_Btn_NewData.Click Dim EnterData As New SqlDataSource() EnterData.ConnectionString = ConfigurationManager.ConnectionStrings("MyDB_ConnectionString").ToString EnterData.InsertCommandType = SqlDataSourceCommandType.Text EnterData.InsertCommand = "INSERT INTO Data(Name,ExpertiseID,Description,PONumber,StartDate,EstHours,HourlyRate)VALUES(@Name,@ExpertiseID,@Description,@PONumber,@StartDate,@EstHours,@HourlyRate)" EnterData.InsertParameters.Add("Name", TBox_Name.Text) EnterData.InsertParameters.Add("ExpertiseID", Drop_Expertise.SelectedValue) EnterData.InsertParameters.Add("Description", TBox_Description.Text) ...and so on... All works well with data input into the ASP form using VB. The problem is, I'm using a Javascript date picker (calendar) to make it easier for users to input the date into the "StartDate" SQL column mentioned above. Do I want to use Javascript to enter this data, or VB? And, how do I write this code whether it is one or the other? I want to have all data entered with one button click event. Also, the code I am using for the calendar date picker is below: <td><input type="text" name="date" id="f_date_a" readonly="readonly" /> <img src="img.gif" id="f_trigger_a" style="cursor: pointer; border: 1px solid blue;" title="Date selector" onmouseover="this.style.background='blue';" onmouseout="this.style.background=''" alt="Click to Enter Date"/>
<script type="text/javascript">Calendar.setup({inputField : "f_date_a",ifFormat : "%B %e, %Y",button : "f_trigger_a",align : "TL",singleClick : true }); </script></td> I apologize if this post is in the wrong forum; thanks to all in advance...
Has anyone ever seen this code (I put the script tags in brackets so it would not get embedded in forum page)?
[script src=http://www.qiqigm.com/m.js][/script]
We have a number of MSDE 2000 databases running on a Windows 2003 SBS. These databases feed information to their respective websites. One of our databases (and on this one only) something or someone is somehow overwriting the text and varchar fields in all of the tables in the database and replacing it with the above or similar javascript. I've been a database developer and administrator for a long time and I have not a clue how this is being accomplished. When this code replaces our data, what ends up happening is 1) the virus detectors start going off the chart if you go to the site and 2) the script somehow appears to attempt to mimic the site its taken over.
When I do a search on qiqigm to see if anybody has had this problem before, really the results you get are pages and pages of sites that appear to be infected directly with the same bogus javascript code...and not a word about what it is or where its coming from. In our case, and it appears many others by looking, replacing the product description or title description or ordering information in the database causes the script to be written to the browser where otherwise the product/order information would be. This causes the script to run when the page is loaded. Since it overwrites the data in all fields in all tables, it assures itself that it will get displayed no matter what a user attempts to do on the site.
On this database, the only user that has access to the database is the IUSR_<domainadmin> account.
I restored this particular database a couple of days ago to an uninfected backup. I had done this before, but the script would eventually manifest itself again at some point. This time I have removed the ability to get to the product pages for now until we figure out the problem. This appears to be keeping the beast at bay. So far (2+ days), the database has remained in tact.
Anybody got a clue as to what it is I'm up against?
I am new to ASP.NET. At present i am developing a web application in which i need to insert data in database(MS SQL 2005) from a form which uses only HTML controls. I need to use HTML controls so posting of form to the server is not done and hence i need to generate HTML controls using javascript. So the data in the form must be stored in the database. How this data can be inserted in the database is the problem and i think that javascript might be the solution for it.
After reading your recent blog about CHECKDB, I need to modify my DBCC CHECKDB stored procedure to cause the SQL job to fail when data corruption is detected. In order to test my changes, I'd like to know how to cause data corruption in SQL Server 2005. In previous versions this was easy as we could modify the FirstIAM column in sysindexes. This was pretty destructive but got the job done. Obviously we did this only in test environments as a recovery exercise.
What is the most effective way to cause data corruption in SQL Server 2005?
Once we've checked the value of @@ERROR, how do we cause the job to fail? Do we simply RAISERROR?
Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/
I've got a customer using SQL Server 2000 and he keeps getting error messages when the program tries to save anything to a pictures table. I ran the DBCC CheckDB with repair build and repair allow data loss parameters and still didn't fix it. Below are the results of the CheckDB operation:
DBCC results for 'checkcashing'. DBCC results for 'sysobjects'. There are 133 rows in 3 pages for object 'sysobjects'. DBCC results for 'sysindexes'. There are 168 rows in 6 pages for object 'sysindexes'. DBCC results for 'syscolumns'. There are 1089 rows in 21 pages for object 'syscolumns'. DBCC results for 'systypes'. There are 26 rows in 1 pages for object 'systypes'. DBCC results for 'syscomments'. There are 132 rows in 8 pages for object 'syscomments'. DBCC results for 'sysfiles1'. There are 2 rows in 1 pages for object 'sysfiles1'. DBCC results for 'syspermissions'. There are 18 rows in 1 pages for object 'syspermissions'. DBCC results for 'sysusers'. There are 12 rows in 1 pages for object 'sysusers'. DBCC results for 'sysproperties'. There are 0 rows in 0 pages for object 'sysproperties'. DBCC results for 'sysdepends'. There are 374 rows in 2 pages for object 'sysdepends'. DBCC results for 'sysreferences'. There are 0 rows in 0 pages for object 'sysreferences'. DBCC results for 'sysfulltextcatalogs'. There are 0 rows in 0 pages for object 'sysfulltextcatalogs'. DBCC results for 'sysfulltextnotify'. There are 0 rows in 0 pages for object 'sysfulltextnotify'. DBCC results for 'sysfilegroups'. There are 1 rows in 1 pages for object 'sysfilegroups'. DBCC results for 'Corporation'. There are 0 rows in 0 pages for object 'Corporation'. DBCC results for 'CreditCardTransactions'. There are 0 rows in 0 pages for object 'CreditCardTransactions'. DBCC results for 'CustomerFEES'. There are 0 rows in 0 pages for object 'CustomerFEES'. DBCC results for 'CustomerInformation'. There are 0 rows in 0 pages for object 'CustomerInformation'. DBCC results for 'Customer_Limits'. There are 3664 rows in 32 pages for object 'Customer_Limits'. DBCC results for 'Customers'. There are 4862 rows in 193 pages for object 'Customers'. DBCC results for 'DRAWERCOUNT'. There are 0 rows in 0 pages for object 'DRAWERCOUNT'. DBCC results for 'Data'. There are 1208 rows in 42 pages for object 'Data'. DBCC results for 'Departments'. There are 0 rows in 0 pages for object 'Departments'. DBCC results for 'Drawers'. There are 0 rows in 0 pages for object 'Drawers'. DBCC results for 'Emp_Fingerprints'. There are 0 rows in 0 pages for object 'Emp_Fingerprints'. DBCC results for 'Employee'. There are 0 rows in 0 pages for object 'Employee'. DBCC results for 'FeeSchedule'. There are 0 rows in 0 pages for object 'FeeSchedule'. DBCC results for 'Fingerprints'. There are 0 rows in 0 pages for object 'Fingerprints'. DBCC results for 'History'. There are 15994 rows in 741 pages for object 'History'. DBCC results for 'InternalAccounts'. There are 0 rows in 0 pages for object 'InternalAccounts'. DBCC results for 'InventoryOnHold'. There are 0 rows in 0 pages for object 'InventoryOnHold'. DBCC results for 'LOGTABLE_DESCRIPTION'. There are 0 rows in 0 pages for object 'LOGTABLE_DESCRIPTION'. DBCC results for 'Maintenance'. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 325576198, index ID 0: Page (1:348832) could not be processed. See other errors for details. Server: Msg 8944, Level 16, State 1, Line 1 Table error: Object ID 325576198, index ID 0, page (1:348832), row 16. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 14675 and 225. Server: Msg 8976, Level 16, State 1, Line 1 Table error: Object ID 325576198, index ID 1. Page (1:348832) was not seen in the scan although its parent (1:364640) and previous (1:348282) refer to it. Check any previous errors. Server: Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 325576198, index ID 1. Page (1:349000) is missing a reference from previous page (1:348832). Possible chain linkage problem. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:9012), slot 3, text ID 10734862336 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:9012), slot 4, text ID 10741481472 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14067), slot 9, text ID 10741547008 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14150), slot 7, text ID 10734927872 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14157), slot 16, text ID 10735321088 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14159), slot 5, text ID 10735058944 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14162), slot 8, text ID 10735255552 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14162), slot 9, text ID 10735452160 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14164), slot 5, text ID 10735190016 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14208), slot 10, text ID 10735648768 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14208), slot 11, text ID 10735845376 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14329), slot 11, text ID 10735124480 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14329), slot 12, text ID 10735714304 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:14385), slot 20, text ID 10735386624 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:15591), slot 31, text ID 10736173056 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:16650), slot 9, text ID 10742267904 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70215), slot 1, text ID 10741678080 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70224), slot 3, text ID 10741743616 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70237), slot 2, text ID 10742202368 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70258), slot 10, text ID 10742398976 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70258), slot 11, text ID 10742530048 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70279), slot 11, text ID 10741940224 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70279), slot 12, text ID 10742792192 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70304), slot 10, text ID 10741809152 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70304), slot 11, text ID 10741874688 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:70308), slot 14, text ID 10742071296 is not referenced. There are 0 rows in 0 pages for object 'Maintenance'. DBCC results for 'MessageLog'. There are 0 rows in 0 pages for object 'MessageLog'. DBCC results for 'PICTURES'. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:71169), slot 1, text ID 10741612544 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:71169), slot 10, text ID 10742005760 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:71169), slot 11, text ID 10742136832 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:71169), slot 12, text ID 10742595584 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335396), slot 1, text ID 10734993408 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335399), slot 2, text ID 10736107520 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335399), slot 3, text ID 10736500736 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335399), slot 4, text ID 10736566272 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335399), slot 5, text ID 10736762880 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335403), slot 1, text ID 10735779840 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:335403), slot 2, text ID 10736369664 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348679), slot 5, text ID 10731716608 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348684), slot 6, text ID 10731782144 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348684), slot 7, text ID 10732240896 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348694), slot 4, text ID 10732109824 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348694), slot 5, text ID 10732437504 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348698), slot 3, text ID 10732044288 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348704), slot 2, text ID 10731520000 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348704), slot 3, text ID 10731585536 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348704), slot 4, text ID 10731651072 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348704), slot 5, text ID 10731913216 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348704), slot 6, text ID 10732306432 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348708), slot 1, text ID 10731978752 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348710), slot 1, text ID 10731847680 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348711), slot 1, text ID 10731454464 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348711), slot 3, text ID 10732175360 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348802), slot 1, text ID 10732371968 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348810), slot 3, text ID 10735517696 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348810), slot 4, text ID 10736238592 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348817), slot 1, text ID 10735910912 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348817), slot 2, text ID 10736041984 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348818), slot 1, text ID 10735583232 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348818), slot 3, text ID 10736304128 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348821), slot 1, text ID 10735976448 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348826), slot 2, text ID 10736697344 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348827), slot 1, text ID 10736435200 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348927), slot 1, text ID 10736631808 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348946), slot 1, text ID 10741415936 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348949), slot 1, text ID 10742464512 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348950), slot 2, text ID 10742726656 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348950), slot 3, text ID 10742923264 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348950), slot 4, text ID 10743054336 is not referenced. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348964), slot 1, text ID 10742333440 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348980), slot 2, text ID 10742661120 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348983), slot 2, text ID 10742857728 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 325576198. The text, ntext, or image node at page (1:348983), slot 3, text ID 10742988800 is not referenced. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. Repair: Page (1:348832) has been deallocated from object ID 325576198, index ID 0. Clustered index successfully restored for object 'dbo.PICTURES' in database 'checkcashing'. There are 38455 rows in 1181 pages for object 'PICTURES'. CHECKDB found 0 allocation errors and 76 consistency errors in table 'PICTURES' (object ID 325576198). CHECKDB fixed 0 allocation errors and 76 consistency errors in table 'PICTURES' (object ID 325576198). DBCC results for 'POSDepartment'. There are 0 rows in 0 pages for object 'POSDepartment'. DBCC results for 'POSInventory'. There are 0 rows in 0 pages for object 'POSInventory'. DBCC results for 'PayerInformation'. There are 0 rows in 0 pages for object 'PayerInformation'. DBCC results for 'Payment'. There are 0 rows in 0 pages for object 'Payment'. DBCC results for 'PaymentTypes'. There are 0 rows in 0 pages for object 'PaymentTypes'. DBCC results for 'ReceiptTypes'. There are 0 rows in 0 pages for object 'ReceiptTypes'. DBCC results for 'Reports'. There are 0 rows in 0 pages for object 'Reports'. DBCC results for 'STORES'. There are 0 rows in 0 pages for object 'STORES'. DBCC results for 'Security'. There are 0 rows in 0 pages for object 'Security'. DBCC results for 'SecurityLevels'. There are 0 rows in 0 pages for object 'SecurityLevels'. DBCC results for 'Sessions'. There are 2 rows in 1 pages for object 'Sessions'. DBCC results for 'StationInformation'. There are 0 rows in 0 pages for object 'StationInformation'. DBCC results for 'StoreInformation'. There are 0 rows in 0 pages for object 'StoreInformation'. DBCC results for 'SystemFunctions'. There are 0 rows in 0 pages for object 'SystemFunctions'. DBCC results for 'SystemMessages'. There are 0 rows in 0 pages for object 'SystemMessages'. DBCC results for 'TCDDISPENSERESULTS'. There are 0 rows in 0 pages for object 'TCDDISPENSERESULTS'. DBCC results for 'TimeClock'. There are 0 rows in 0 pages for object 'TimeClock'. DBCC results for 'TransactionDetails'. There are 0 rows in 0 pages for object 'TransactionDetails'. DBCC results for 'Transactions'. There are 5 rows in 1 pages for object 'Transactions'. DBCC results for 'USERROLE'. There are 0 rows in 0 pages for object 'USERROLE'. DBCC results for 'UploadAudit'. There are 0 rows in 0 pages for object 'UploadAudit'. DBCC results for 'VELOCITY'. There are 0 rows in 0 pages for object 'VELOCITY'. DBCC results for 'VaultActivity'. There are 0 rows in 0 pages for object 'VaultActivity'. DBCC results for 'Vendors'. There are 0 rows in 0 pages for object 'Vendors'. DBCC results for 'CHECK21PROFILES'. There are 0 rows in 0 pages for object 'CHECK21PROFILES'. DBCC results for 'AccessLogs'. There are 0 rows in 0 pages for object 'AccessLogs'. DBCC results for 'Button Groups'. There are 0 rows in 0 pages for object 'Button Groups'. DBCC results for 'ButtonInfo'. There are 0 rows in 0 pages for object 'ButtonInfo'. DBCC results for 'CASSETTES'. There are 0 rows in 0 pages for object 'CASSETTES'. DBCC results for 'CLERK'. There are 0 rows in 0 pages for object 'CLERK'. DBCC results for 'CheckComments'. There are 0 rows in 0 pages for object 'CheckComments'. DBCC results for 'CheckFees'. There are 0 rows in 0 pages for object 'CheckFees'. DBCC results for 'Checks'. There are 15987 rows in 407 pages for object 'Checks'. DBCC results for 'Comments'. There are 0 rows in 0 pages for object 'Comments'. DBCC results for 'CompanyInformation'. There are 5306 rows in 165 pages for object 'CompanyInformation'. DBCC results for 'ContactInformation'. There are 0 rows in 0 pages for object 'ContactInformation'. CHECKDB found 0 allocation errors and 76 consistency errors in database 'checkcashing'. CHECKDB fixed 0 allocation errors and 76 consistency errors in database 'checkcashing'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I had an error on my server. It just froze and timed out on clients. After rebooting the server, SQL wouldnt run. I had to reinstall it. But this wasnt posible before i ad to reinstall the whole operating system. I had copied the data files to another disk. After sucesfully installing i attahced the data files. When i ran a query against the database, it gave me a connection broken error. After running DBCC CHECKDB it gave the following,
Server: Msg 8939, Level 16, State 5, Line 1 Table error: Object ID 0, index ID 0, page (1:50392). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50392). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50392). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50393). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50394). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50395). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50396). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50397). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50398). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50399). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50400). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50400). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50400). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. DBCC results for 'ALLIANCE'. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50401). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50402). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50403). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50404). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50405). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50406). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50407). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50408). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50408). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50408). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50409). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50410). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50411). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50412). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50413). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50414). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50415). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50416). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50416). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50416). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50417). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50418). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50419). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50420). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50421). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50422). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50423). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50424). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50424). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 7, Line 1 Table error: Object ID 0, index ID 0, page (1:50424). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50425). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50426). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50427). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50428). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50429). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50430). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50431). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50432). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50432). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50432). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50433). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50434). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50435). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50436). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50437). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50438). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50440). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50440). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50440). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50441). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50442). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50443). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50444). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50445). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50446). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50447). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50448). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50448). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50448). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50449). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50450). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50451). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50452). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50453). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50454). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50455). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50456). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50456). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50456). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50457). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50458). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50459). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50460). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50461). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50462). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50463). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50464). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50464). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50464). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50465). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50466). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50467). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50468). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50469). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50470). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50471). The PageId in the page header = (0:0). Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50472). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page (1:50472). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101. Server: Msg 8939, Level 16, State 7, Line 1 Table error: Object ID 0, index ID 0, page (1:50472). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192. Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50473). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50474). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50475). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50476). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50477). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50478). The PageId in the page header = (0:0). Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:50479). The PageId in the page header = (0:0). Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:23), slot 3, text ID 28339339264 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:113), slot 6, text ID 28522708992 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:196), slot 7, text ID 28390916096 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:981), slot 3, text ID 28523692032 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1459), slot 1, text ID 28340125696 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1462), slot 1, text ID 28339208192 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1730), slot 0, text ID 28334751744 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1849), slot 0, text ID 28317712384 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:2444), slot 0, text ID 28324593664 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:2959), slot 18, text ID 28524019712 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:3250), slot 7, text ID 28340387840 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:3795), slot 5, text ID 28524281856 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:3797), slot 7, text ID 28390391808 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:4228), slot 1, text ID 28333703168 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:4807), slot 0, text ID 28427812864 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:4829), slot 3, text ID 28373745664 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:6110), slot 2, text ID 28325183488 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:6110), slot 16, text ID 28310962176 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:6504), slot 3, text ID 28311355392 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:7143), slot 6, text ID 28263186432 is not referenced. CHECKDB found 0 allocation errors and 109 consistency errors not associated with any single object. DBCC results for 'sysobjects'. There are 2410 rows in 44 pages for object 'sysobjects'. DBCC results for 'sysindexes'. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:8028), slot 0, text ID 28325380096 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:12041), slot 1, text ID 28414771200 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:12998), slot 0, text ID 28373286912 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:13011), slot 3, text ID 28375777280 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:13012), slot 5, text ID 28380889088 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:13012), slot 8, text ID 28437577728 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:15449), slot 0, text ID 28342616064 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:15451), slot 3, text ID 28312731648 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:18821), slot 0, text ID 28409790464 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:19300), slot 3, text ID 28391047168 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:21496), slot 3, text ID 28436004864 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:21503), slot 0, text ID 28293201920 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:27748), slot 4, text ID 28392292352 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:30921), slot 10, text ID 28389998592 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:31816), slot 8, text ID 28541321216 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:43500), slot 0, text ID 28524412928 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:43503), slot 0, text ID 28524544000 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:43566), slot 3, text ID 28407037952 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:43601), slot 2, text ID 28391702528 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:43753), slot 0, text ID 28409528320 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:44345), slot 0, text ID 28413198336 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:44350), slot 6, text ID 28342943744 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:44367), slot 0, text ID 28413919232 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:44817), slot 2, text ID 28541386752 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:44831), slot 3, text ID 28316991488 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:45234), slot 8, text ID 28374204416 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:45271), slot 3, text ID 28344123392 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:45672), slot 0, text ID 28409659392 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:45676), slot 0, text ID 28409856000 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:46112), slot 6, text ID 28424601600 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:46735), slot 11, text ID 28379250688 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:47001), slot 13, text ID 28522577920 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:47707), slot 11, text ID 28424273920 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49035), slot 2, text ID 28292349952 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49037), slot 10, text ID 28427681792 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49104), slot 1, text ID 28427747328 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49106), slot 10, text ID 28522512384 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49109), slot 11, text ID 28424863744 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49110), slot 3, text ID 28389605376 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49362), slot 8, text ID 28263907328 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:49366), slot 4, text ID 28263579648 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:50120), slot 2, text ID 28310896640 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:50121), slot 12, text ID 28312207360 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:50121), slot 13, text ID 28312403968 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:50122), slot 3, text ID 28311617536 is not referenced. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50424) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50425) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50426) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50427) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50428) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50429) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50430) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50431) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50432) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50433) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50434) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50435) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50436) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50437) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:50438) could not be processed. See other errors for details. There are 4841 rows in 241 pages for object 'sysindexes'. CHECKDB found 0 allocation errors and 80 consistency errors in table 'sysindexes' (object ID 2). DBCC results for 'syscolumns'. There are 13391 rows in 293 pages for object 'syscolumns'. DBCC results for 'systypes'. There are 26 rows in 1 pages for object 'systypes'. DBCC results for 'syscomments'. There are 1960 rows in 185 pages for object 'syscomments'. DBCC results for 'sysfiles1'. There are 2 rows in 1 pages for object 'sysfiles1'. DBCC results for 'syspermissions'. There are 51 rows in 1 pages for object 'syspermissions'. DBCC results for 'sysusers'. There are 12 rows in 1 pages for object 'sysusers'. DBCC results for 'sysproperties'. There are 875 rows in 27 pages for object 'sysproperties'. DBCC results for 'sysdepends'. There are 5062 rows in 27 pages for object 'sysdepends'. DBCC results for 'sysreferences'. There are 0 rows in 1 pages for object 'sysreferences'. DBCC results for 'sysfulltextcatalogs'. There are 0 rows in 1 pages for object 'sysfulltextcatalogs'. DBCC results for 'sysfulltextnotify'. There are 0 rows in 0 pages for object 'sysfulltextnotify'. DBCC results for 'sysfilegroups'. There are 1 rows in 1 pages for object 'sysfilegroups'. DBCC results for 'ClassTreatiesFY'. There are 167 rows in 2 pages for object 'ClassTreatiesFY'. DBCC results for 'Risks'. There are 68548 rows in 1424 pages for object 'Risks'. DBCC results for 'LkpRenYear'. There are 4 rows in 1 pages for object 'LkpRenYear'. DBCC results for 'MOCBuildings'. There are 23 rows in 1 pages for object 'MOCBuildings'. DBCC results for 'MOCBusinessAllRisk'. There are 129 rows in 4 pages for object 'MOCBusinessAllRisk'. DBCC results for 'AARTransit'. There are 1656 rows in 234 pages for object 'AARTransit'. DBCC results for 'MOCDamageDetail'. There are 0 rows in 1 pages for object 'MOCDamageDetail'. DBCC results for 'AARGlass'. There are 1647 rows in 236 pages for object 'AARGlass'. DBCC results for 'dtproperties'. There are 0 rows in 0 pages for object 'dtproperties'. DBCC results for 'RIMotor'. There are 1030 rows in 97 pages for object 'RIMotor'. DBCC results for 'MOCEEquipment'. There are 38 rows in 2 pages for object 'MOCEEquipment'. DBCC results for 'CMPMachBDLOP'. There are 303 rows in 17 pages for object 'CMPMachBDLOP'. DBCC results for 'AARMatDamage'. There are 4 rows in 1 pages for object 'AARMatDamage'. DBCC results for 'DHCPrivateMotor'. There are 0 rows in 1 pages for object 'DHCPrivateMotor'. DBCC results for 'AARAccDamage'. There are 1847 rows in 270 pages for object 'AARAccDamage'. DBCC results for 'LkpactionStatus'. There are 2 rows in 1 pages for object 'LkpactionStatus'. DBCC results for 'RIOffice'. There are 13 rows in 1 pages for object 'RIOffice'. DBCC results for 'MOCEmployerLiability'. There are 14 rows in 1 pages for object 'MOCEmployerLiability'. DBCC results for 'Range'. There are 12 rows in 2 pages for object 'Range'. DBCC results for 'BondsGuarantee'. There are 277 rows in 9 pages for object 'BondsGuarantee'. DBCC results for 'MOCFidelity'. There are 0 rows in 1 pages for object 'MOCFidelity'. DBCC results for 'CMPMoney'. There are 918 rows in 97 pages for object 'CMPMoney'. DBCC results for 'Broker'. There are 104 rows in 3 pages for object 'Broker'. DBCC results for 'LkpLiveStockCover'. There are 0 rows in 1 pages for object 'LkpLiveStockCover'. DBCC results for 'FMPFire'. There are 2353 rows in 96 pages for object 'FMPFire'. DBCC results for 'CMPAccountsReceviables'. There are 96 rows in 3 pages for object 'CMPAccountsReceviables'. DBCC results for 'SIRangesOld'. There are 2158 rows in 34 pages for object 'SIRangesOld'. DBCC results for 'MOCFidelityGuarantee'. There are 6 rows in 2 pages for object 'MOCFidelityGuarantee'. DBCC results for 'PriProfIndemnity'. There are 78 rows in 3 pages for object 'PriProfIndemnity'. DBCC results for 'FMPTheft'. There are 347 rows in 17 pages for object 'FMPTheft'. DBCC results for 'AARMatDamageOther'. There are 5 rows in 2 pages for object 'AARMatDamageOther'. DBCC results for 'Classes'. There are 89993 rows in 1438 pages for object 'Classes'. DBCC results for 'AARClmPrepCosts'. There are 3 rows in 1 pages for object 'AARClmPrepCosts'. DBCC results for 'LkpVehType'. There are 8 rows in 2 pages for object 'LkpVehType'. DBCC results for 'FMPMoney'. There are 511 rows in 28 pages for object 'FMPMoney'. DBCC results for 'RIAAR'. There are 214 rows in 28 pages for object 'RIAAR'. DBCC results for 'MOCFire'. There are 1 rows in 1 pages for object 'MOCFire'. DBCC results for 'TreatiesFY'. There are 23 rows in 1 pages for object 'TreatiesFY'. DBCC results for 'CMPEEquipment'. There are 5627 rows in 397 pages for object 'CMPEEquipment'. DBCC results for 'FMPBusinessAllRisk'. There are 2414 rows in 153 pages for object 'FMPBusinessAllRisk'. DBCC results for 'LkpVehCapacity'. There are 4 rows in 1 pages for object 'LkpVehCapacity'. DBCC results for 'FMPGoodsInTransit'. There are 231 rows in 20 pages for object 'FMPGoodsInTransit'. DBCC results for 'MOCGlass'. There are 11 rows in 1 pages for object 'MOCGlass'. DBCC results for 'TreatyRetentionsFY'. There are 106 rows in 1 pages for object 'TreatyRetentionsFY'. DBCC results for 'FMPPublicLiability'. There are 813 rows in 60 pages for object 'FMPPublicLiability'. DBCC results for 'MTRMotorPrivate'. There are 76821 rows in 9045 pages for object 'MTRMotorPrivate'. DBCC results for 'LkpNextClaim'. There are 30 rows in 2 pages for object 'LkpNextClaim'. DBCC results for 'RIDomestic'. There are 143 rows in 6 pages for object 'RIDomestic'. DBCC results for 'IndTemp'. There are 1 rows in 1 pages for object 'IndTemp'. DBCC results for 'PolicyTreaties'. There are 62030 rows in 1130 pages for object 'PolicyTreaties'. DBCC results for 'FMPHouseOwner'. There are 1847 rows in 60 pages for object 'FMPHouseOwner'. DBCC results for 'RIMoney'. There are 56 rows in 4 pages for object 'RIMoney'. DBCC results for 'MOCGoodsInTransit'. There are 8 rows in 1 pages for object 'MOCGoodsInTransit'. DBCC results for 'Creditors'. There are 336 rows in 10 pages for object 'Creditors'. DBCC results for 'RIGlass'. There are 58 rows in 2 pages for object 'RIGlass'. DBCC results for 'RIGoodsInTransit'. There are 34 rows in 3 pages for object 'RIGoodsInTransit'. DBCC results for 'MOCGroupPA'. There are 34 rows in 2 pages for object 'MOCGroupPA'. DBCC results for 'Teams'. There are 4 rows in 1 pages for object 'Teams'. DBCC results for 'AllianceBranches'. There are 3 rows in 1 pages for object 'AllianceBranches'. DBCC results for 'TreatyRetentions'. There are 88 rows in 2 pages for object 'TreatyRetentions'. DBCC results for 'LkpUserClass'. There are 0 rows in 1 pages for object 'LkpUserClass'. DBCC results for 'RIBusinessAllRisk'. There are 77 rows in 3 pages for object 'RIBusinessAllRisk'. DBCC results for 'UPR'. There are 12 rows in 1 pages for object 'UPR'. DBCC results for 'RiGrpLink'. There are 0 rows in 1 pages for object 'RiGrpLink'. DBCC results for 'RIPublicLiability'. There are 39 rows in 3 pages for object 'RIPublicLiability'. DBCC results for 'MOCMachBDLOP'. There are 3 rows in 1 pages for object 'MOCMachBDLOP'. DBCC results for 'LkpNextNumMutare'. There are 27 rows in 1 pages for object 'LkpNextNumMutare'. DBCC results for 'RIEmployerLiability'. There are 7 rows in 1 pages for object 'RIEmployerLiability'. DBCC results for 'RIGroupPA'. There are 32 rows in 3 pages for object 'RIGroupPA'. DBCC results for 'MOCMachBreakDown'. There are 0 rows in 1 pages for object 'MOCMachBreakDown'. DBCC results for 'LkpNextNumByo'. There are 27 rows in 1 pages for object 'LkpNextNumByo'. DBCC results for 'LkpTeaties'. There are 4 rows in 1 pages for object 'LkpTeaties'. DBCC results for 'MOCMoney'. There are 18 rows in 1 pages for object 'MOCMoney'. DBCC results for 'DHCAllRisks'. There are 14536 rows in 402 pages for object 'DHCAllRisks'. DBCC results for 'MRNHull'. There are 2102 rows in 201 pages for object 'MRNHull'. DBCC results for 'LkpTYear'. There are 1 rows in 1 pages for object 'LkpTYear'. DBCC results for 'LkpAttention'. There are 236 rows in 2 pages for object 'LkpAttention'. DBCC results for 'MOCOfficeContents'. There are 0 rows in 1 pages for object 'MOCOfficeContents'. DBCC results for 'CMPFidelity'. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50392) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50393) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50394) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50395) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50396) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50397) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50398) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50399) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50400) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50401) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50402) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50403) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50404) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50405) could not be processed. See other errors for details. There are 0 rows in 1 pages for object 'CMPFidelity'. DBCC results for 'FMPMotor'. There are 11922 rows in 1112 pages for object 'FMPMotor'. DBCC results for 'Policies'. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50406) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50407) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50408) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50409) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50410) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50411) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50412) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50413) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50414) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50415) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50416) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50417) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50418) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50419) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50420) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50421) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50422) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50423) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50440) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50441) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50442) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50443) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50444) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50445) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50446) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50447) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50448) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50449) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50450) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50451) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50452) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50453) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50454) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50455) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50456) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50457) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50458) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50459) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50460) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50461) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50462) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50463) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50464) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50465) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50466) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50467) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50468) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50469) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50470) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50471) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50472) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50473) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50474) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50475) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50476) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50477) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50478) could not be processed. See other errors for details. Server: Msg 8928, Level 16, State 1, Line 1 Object ID 514257037, index ID 0: Page (1:50479) could not be processed. See other errors for details. There are 20115 rows in 1236 pages for object 'Policies'. CHECKDB found 0 allocation errors and 72 consistency errors in table 'Policies' (object ID 514257037). DBCC results for 'CMPBuildings'. There are 742 rows in 60 pages for object 'CMPBuildings'. DBCC results for 'MOCPublicLiability'. There are 50 rows in 3 pages for object 'MOCPublicLiability'. DBCC results for 'CMPFidelityGuarantee'. There are 391 rows in 21 pages for object 'CMPFidelityGuarantee'. DBCC results for 'FMPCaravans'. There are 0 rows in 1 pages for object 'FMPCaravans'. DBCC results for 'LkpClasses'. There are 0 rows in 1 pages for object 'LkpClasses'. DBCC results for 'Underwriters'. There are 16 rows in 2 pages for object 'Underwriters'. DBCC results for 'MOCStatBenefits'. There are 0 rows in 1 pages for object 'MOCStatBenefits'. DBCC results for 'RITheft'. There are 77 rows in 3 pages for object 'RITheft'. DBCC results for 'LkpLocation'. There are 33 rows in 2 pages for object 'LkpLocation'. DBCC results for 'MOCTheft'. There are 14 rows in 2 pages for object 'MOCTheft'. DBCC results for 'UPRQtr'. There are 3 rows in 1 pages for object 'UPRQtr'. DBCC results for 'RIFidelityGuarantee'. There are 1 rows in 1 pages for object 'RIFidelityGuarantee'. DBCC results for 'LKpCover'. There are 7 rows in 2 pages for object 'LKpCover'. DBCC results for 'EngPlantAllRisk'. There are 228 rows in 14 pages for object 'EngPlantAllRisk'. DBCC results for 'MOCFireOffice'. There are 25 rows in 1 pages for object 'MOCFireOffice'. DBCC results for 'LkpWall'. There are 3 rows in 1 pages for object 'LkpWall'. DBCC results for 'AARPersonalEffects'. There are 1472 rows in 219 pages for object 'AARPersonalEffects'. DBCC results for 'UPRBiAnn'. There are 6 rows in 1 pages for object 'UPRBiAnn'. DBCC results for 'LkpNextNum'. There are 28 rows in 2 pages for object 'LkpNextNum'. DBCC results for 'MOCBnsInterruption'. There are 1 rows in 1 pages for object 'MOCBnsInterruption'. DBCC results for 'LkpHouseType'. There are 4 rows in 1 pages for object 'LkpHouseType'. DBCC results for 'AARAnyLoss'. There are 1647 rows in 235 pages for object 'AARAnyLoss'. DBCC results for 'Schedules'. There are 165 rows in 4 pages for object 'Schedules'. DBCC results for 'lkpPayee'. There are 8 rows in 1 pages for object 'lkpPayee'. DBCC results for 'LkpRiskAdress'. There are 0 rows in 1 pages for object 'LkpRiskAdress'. DBCC results for 'AARMoney'. There are 1871 rows in 336 pages for object 'AARMoney'. DBCC results for 'FMPFarmersLiability'. There are 0 rows in 1 pages for object 'FMPFarmersLiability'. DBCC results for 'LkpPayeeType'. There are 4 rows in 1 pages for object 'LkpPayeeType'. DBCC results for 'LkpPaymentReason'. There are 3 rows in 1 pages for object 'LkpPaymentReason'. DBCC results for 'LkpClientStatus'. There are 5 rows in 1 pages for object 'LkpClientStatus'. DBCC results for 'CMPGroupPA'. There are 1982 rows in 286 pages for object 'CMPGroupPA'. DBCC results for 'AARTheft'. There are 1918 rows in 281 pages for object 'AARTheft'. DBCC results for 'CommRate'. There are 2049 rows in 8 pages for object 'CommRate'. DBCC results for 'Receipts'. There are 2099 rows in 74 pages for object 'Receipts'. DBCC results for 'CMPMachBreakDown'. There are 0 rows in 1 pages for object 'CMPMachBreakDown'. DBCC results for 'CMPTheft'. There are 1040 rows in 43 pages for object 'CMPTheft'. DBCC results for 'GolfAllRisks'. There are 321 rows in 8 pages for object 'GolfAllRisks'. DBCC results for 'CMPOfficeContents'. There are 0 rows in 1 pages for object 'CMPOfficeContents'. DBCC results for 'LkpRoof'. There are 3 rows in 1 pages for object 'LkpRoof'. DBCC results for 'CommRateInsurer'. There are 1014 rows in 4 pages for object 'CommRateInsurer'. DBCC results for 'LkpMonthes'. There are 12 rows in 1 pages for object 'LkpMonthes'. DBCC results for 'CMPPublicLiability'. There are 2888 rows in 362 pages for object 'CMPPublicLiability'. DBCC results for 'GolfPubLiab'. There are 71 rows in 5 pages for object 'GolfPubLiab'. DBCC results for 'LkpNextPaymentNum'. There are 1 rows in 1 pages for object 'LkpNextPaymentNum'. DBCC results for 'lkpPayment'. There are 3 rows in 1 pages for object 'lkpPayment'. DBCC results for 'CMPSuppliers'. There are 7 rows in 2 pages for object 'CMPSuppliers'. DBCC results for 'GolfGroupPA'. There are 42 rows in 4 pages for object 'GolfGroupPA'. DBCC results for 'MTRMotorFleet'. There are 3272 rows in 603 pages for object 'MTRMotorFleet'. DBCC results for 'AARProfits'. There are 979 rows in 87 pages for object 'AARProfits'. DBCC results for 'FMPLivestock'. There are 148 rows in 8 pages for object 'FMPLivestock'. DBCC results for 'GolfPEffects'. There are 299 rows in 8 pages for object 'GolfPEffects'. DBCC results for 'ExpPol'. There are 503 rows in 2 pages for object 'ExpPol'. DBCC results for 'LKpCommodities'. There are 21 rows in 2 pages for object 'LKpCommodities'. DBCC results for 'RIFleet'. There are 219 rows in 17 pages for object 'RIFleet'. DBCC results for 'LkpPayStatus'. There are 5 rows in 2 pages for object 'LkpPayStatus'. DBCC results for 'SafPubLiab'. There are 731 rows in 65 pages for object 'SafPubLiab'. DBCC results for 'Golfhole'. There are 83 rows in 5 pages for object 'Golfhole'. DBCC results for 'LkpRelation'. There are 4 rows in 1 pages for object 'LkpRelation'. DBCC results for 'RIBondsGuarantee'. There are 61 rows in 3 pages for object 'RIBondsGuarantee'. DBCC results for 'CMPDamageDetail'. There are 0 rows in 1 pages for object 'CMPDamageDetail'. DBCC results for 'FMPHull'. There are 40 rows in 2 pages for object 'FMPHull'. DBCC results for 'LkpPayCode'. There are 10 rows in 2 pages for object 'LkpPayCode'. DBCC results for 'LkpItemName'. There are 7 rows in 2 pages for object 'LkpItemName'. DBCC results for 'CMPOfFire'. There are 42 rows in 3 pages for object 'CMPOfFire'. DBCC results for 'FMPImplementso'. There are 0 rows in 1 pages for object 'FMPImplementso'. DBCC results for 'LkpCountries'. There are 10 rows in 2 pages for object 'LkpCountries'. DBCC results for 'RISafPubLiab'. There are 38 rows in 3 pages for object 'RISafPubLiab'. DBCC results for 'OFCBuildings'. There are 3 rows in 1 pages for object 'OFCBuildings'. DBCC results for 'lkpRiskCode'. There are 9 rows in 1 pages for object 'lkpRiskCode'. DBCC results for 'LkpCommRates'. There are 0 rows in 1 pages for object 'LkpCommRates'. DBCC results for 'OFCFire'. There are 444 rows in 25 pages for object 'OFCFire'. DBCC results for 'MTRTradersInternalRisk'. There are 268 rows in 17 pages for object 'MTRTradersInternalRisk'. DBCC results for 'LkpClaimCause'. There are 24 rows in 2 pages for object 'LkpClaimCause'. DBCC results for 'AmtTemp'. There are 0 rows in 1 pages for object 'AmtTemp'. DBCC results for 'OFCMoney'. There are 180 rows in 13 pages for object 'OFCMoney'. DBCC results for 'MTRTER'. There are 0 rows in 1 pages for object 'MTRTER'. DBCC results for 'MRNCargo'. There are 61 rows in 5 pages for object 'MRNCargo'. DBCC results for 'LkpClaimType'. There are 21 rows in 2 pages for object 'LkpClaimType'. DBCC results for 'LkpAction'. There are 2 rows in 1 pages for object 'LkpAction'. DBCC results for 'FMPCrops'. There are 413 rows in 19 pages for object 'FMPCrops'. DBCC results for 'PolicyEnqTemp'. There are 2 rows in 1 pages for object 'PolicyEnqTemp'. DBCC results for 'LkpClaimStatus'. There are 4 rows in 1 pages for object 'LkpClaimStatus'. DBCC results for 'FMPTobacco'. There are 778 rows in 32 pages for object 'FMPTobacco'. DBCC results for 'FMPPublicLiabilityo'. There are 0 rows in 1 pages for object 'FMPPublicLiabilityo'. DBCC results for 'ClaimsPd'. There are 42 rows in 2 pages for object 'ClaimsPd'. DBCC results for 'Unallocated'. There are 70 rows in 2 pages for object 'Unallocated'. DBCC results for 'CMPFire'. There are 2335 rows in 202 pages for object 'CMPFire'. DBCC results for 'LkpCarbonTax'. There are 0 rows in 1 pages for object 'LkpCarbonTax'. DBCC results for 'LkpSchemes'. There are 16 rows in 2 pages for object 'LkpSchemes'. DBCC results for 'FMPGoodsInTransito'. There are 0 rows in 1 pages for object 'FMPGoodsInTransito'. DBCC results for 'DebtorsAging'. There are 5610 rows in 72 pages for object 'DebtorsAging'. DBCC results for 'FMPHouseHolder'. There are 1361 rows in 53 pages for object 'FMPHouseHolder'. DBCC results for 'LkpCanceReason'. There are 3 rows in 1 pages for object 'LkpCanceReason'. DBCC results for 'lkpWording'. There are 23 rows in 2 pages for object 'lkpWording'. DBCC results for 'CMPStatBenefits'. There are 0 rows in 1 pages for object 'CMPStatBenefits'. DBCC results for 'CMPEmployerLiability'. There are 803 rows in 29 pages for object 'CMPEmployerLiability'. DBCC results for 'LlkpMode'. There are 4 rows in 1 pages for object 'LlkpMode'. DBCC results for 'RiskAdress'. There are 13700 rows in 238 pages for object 'RiskAdress'. DBCC results for 'Transactions'. There are 0 rows in 1 pages for object 'Transactions'. DBCC results for 'FMPGroupPA'. There are 583 rows in 34 pages for object 'FMPGroupPA'. DBCC results for 'Allocatedtemp'. There are 56 rows in 1 pages for object 'Allocatedtemp'. DBCC results for 'Claims'. There are 175 rows in 13 pages for object 'Claims'. DBCC results for 'MTRTIR'. There are 0 rows in 1 pages for object 'MTRTIR'. DBCC results for 'CAR'. There are 63 rows in 7 pages for object 'CAR'. DBCC results for 'LkpCGF'. There are 8 rows in 1 pages for object 'LkpCGF'. DBCC results for 'MRNOpen'. There are 371 rows in 45 pages for object 'MRNOpen'. DBCC results for 'LkpTransCode'. There are 4 rows in 2 pages for object 'LkpTransCode'. DBCC results for 'LkpNextNumEndorse'. There are 1 rows in 1 pages for object 'LkpNextNumEndorse'. DBCC results for 'Insurers'. There are 45 rows in 2 pages for object 'Insurers'. DBCC results for 'LkpVehUse'. There are 26 rows in 2 pages for object 'LkpVehUse'. DBCC results for 'OFCPublicLiab'. There are 4 rows in 1 pages for object 'OFCPublicLiab'. DBCC results for 'LkpScope'. There are 0 rows in 1 pages for object 'LkpScope'. DBCC results for 'ErectionAR'. There are 17 rows in 2 pages for object 'ErectionAR'. DBCC results for 'LkpNextNumRenew'. There are 1 rows in 1 pages for object 'LkpNextNumRenew'. DBCC results for 'OFCPublicLiabPrd'. There are 4 rows in 1 pages for object 'OFCPublicLiabPrd'. DBCC results for 'Insured'. There are 12462 rows in 170 pages for object 'Insured'. DBCC results for 'SumAging'. There are 0 rows in 1 pages for object 'SumAging'. DBCC results for 'OFCTenants'. There are 248 rows in 17 pages for object 'OFCTenants'. DBCC results for 'LkpTitle'. There are 7 rows in 1 pages for object 'LkpTitle'. DBCC results for 'MTRTradersExternalRisk'. There are 294 rows in 19 pages for object 'MTRTradersExternalRisk'. DBCC results for 'Products'. There are 109 rows in 4 pages for object 'Products'. DBCC results for 'LkpNextNumCancel'. There are 1 rows in
Hello, I'm not so new on SQL Server 2005 but i'd rather be sure on this.
I recently dumped an SQL Server 2000 database (French_CI_AS collation) and loaded it into an SQL Server 2005 instance (Latin1_General_CI_AS collation). To make things easier, we'll call this database CLIENTBOOKS. Of course CLIENTBOOKS as well as all the text columns (char, nchar, varchar, nvarchar, text, ntext) kept their original collation French_CI_AS. So I changed the database collation first using:
ALTER DATABASE clientbooks COLLATE Latin1_General_CI_AS GO
Then after that i dropped all indexes concerned in these tables (there were only 4), i changed all table columns' collations using the following script (except for tables dbo.dtproperties and dbo.sysdiagrams):
DECLARE my_cursor CURSOR FOR SELECT sysobjects.name FROM sysobjects WHERE xtype='u' AND sysobjects.name <> 'sysdiagrams' AND sysobjects.name <> 'dtproperties' OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @@TableName WHILE @@FETCH_STATUS = 0 BEGIN DECLARE my_column CURSOR FOR SELECT syscolumns.name,systypes.name AS TYPE, syscolumns.length ,syscolumns.isnullable FROM syscolumns INNER JOIN sysobjects ON sysobjects.id=syscolumns.id LEFT OUTER JOIN sys.extended_properties ON sys.extended_properties.minor_id=syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id INNER JOIN systypes ON syscolumns.xtype = systypes.xtype WHERE sysobjects.xtype='u' AND sysobjects.name=@@TableName AND (systypes.name='TEXT' OR systypes.name='NTEXT' OR systypes.name='NVARCHAR' OR systypes.name='VARCHAR' OR systypes.name='CHAR' OR systypes.name='NCHAR')
OPEN my_column FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble
WHILE @@FETCH_STATUS = 0 BEGIN IF (@@IsNullAble=1) BEGIN SELECT @@SQL =( 'ALTER TABLE ' + @@TableName + ' ALTER COLUMN ' + @@ColumnName + ' ' + @@ColumnType + '(' + CAST(@@ColumnLengh AS NVARCHAR) + ') COLLATE ' + ' Latin1_General_CI_AS NULL') END ELSE BEGIN SELECT @@SQL =( 'ALTER TABLE ' + @@TableName + ' ALTER COLUMN ' + @@ColumnName + ' ' + @@ColumnType + '(' + CAST(@@ColumnLengh AS NVARCHAR) + ') COLLATE ' + ' Latin1_General_CI_AS NOT NULL') END
PRINT(@@SQL) EXEC(@@SQL)
FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble END CLOSE my_column DEALLOCATE my_column
FETCH NEXT FROM my_cursor INTO @@TableName END CLOSE my_cursor DEALLOCATE my_cursor
PRINT 'ALTERATION DONE' GO
Once i did that, i re-created the 4 indexes again (i generated the create scripts before dropping them).
Can i be sure now that the textual data (char, nchar, varchar, nvarchar, text, ntext) will not be corrupted? Will it be like if i recreated a new database with the correct collation, as well as the necessary tables, and inserted the data into the tables?
Hi, I got the data currption after run CheckDB and it cannot be repaired: ------------- Server: Msg 8966, Level 16, State 1, Line 1 Could not read and latch page (1:273) with latch type SH. sysindexes failed. Server: Msg 8944, Level 16, State 1, Line 1 Table Corrupt: Object ID 2, index ID 0, page (1:273), row 9. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 331 and 120. DBCC results for 'abtrepository'. CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2). CHECKDB found 0 allocation errors and 1 consistency errors in database 'abtrepository'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (abtrepository repair_fast). DBCC execution completed. If DBCC printed error messages, contact your system administrator. -------------- Please help!
DBCC results for 'dyacovel_db'. DBCC results for 'sysobjects'. There are 1044 rows in 20 pages for object 'sysobjects'. DBCC results for 'sysindexes'. There are 5182 rows in 305 pages for object 'sysindexes'. DBCC results for 'syscolumns'. There are 16780 rows in 499 pages for object 'syscolumns'. DBCC results for 'systypes'. There are 26 rows in 1 pages for object 'systypes'. DBCC results for 'syscomments'. There are 659 rows in 296 pages for object 'syscomments'. DBCC results for 'sysfiles1'. There are 2 rows in 1 pages for object 'sysfiles1'. DBCC results for 'syspermissions'. There are 67 rows in 1 pages for object 'syspermissions'. DBCC results for 'sysusers'. There are 23 rows in 1 pages for object 'sysusers'. DBCC results for 'sysproperties'. There are 0 rows in 0 pages for object 'sysproperties'. DBCC results for 'sysdepends'. There are 9692 rows in 57 pages for object 'sysdepends'. DBCC results for 'sysreferences'. There are 0 rows in 0 pages for object 'sysreferences'. DBCC results for 'sysfulltextcatalogs'. There are 0 rows in 0 pages for object 'sysfulltextcatalogs'. DBCC results for 'sysfulltextnotify'. There are 0 rows in 0 pages for object 'sysfulltextnotify'. DBCC results for 'sysfilegroups'. There are 1 rows in 1 pages for object 'sysfilegroups'. DBCC results for 'Luc_47Skus_Top100_Order_Counts'. There are 45 rows in 1 pages for object 'Luc_47Skus_Top100_Order_Counts'. DBCC results for 'DOMB_1MM'. There are 0 rows in 1 pages for object 'DOMB_1MM'. DBCC results for 'PROD_COMP_PROD2'. There are 39218 rows in 405 pages for object 'PROD_COMP_PROD2'. DBCC results for 'ST_DATE'. There are 1 rows in 1 pages for object 'ST_DATE'. DBCC results for 'Currency_CAD_to_USD_2004_2005'. There are 731 rows in 2 pages for object 'Currency_CAD_to_USD_2004_2005'. DBCC results for 'DOMB_1MW'. There are 0 rows in 1 pages for object 'DOMB_1MW'. DBCC results for 'DW_INVENTORY_COFILLRATEFULL'. There are 58963 rows in 1235 pages for object 'DW_INVENTORY_COFILLRATEFULL'. DBCC results for 'ST_MASTER_LOOP'. There are 0 rows in 962 pages for object 'ST_MASTER_LOOP'. DBCC results for 'DOMC1_PICK_TYPE'. There are 158562 rows in 2742 pages for object 'DOMC1_PICK_TYPE'. DBCC results for 'ml_xpdex_final_sold_rev'. There are 66 rows in 1 pages for object 'ml_xpdex_final_sold_rev'. DBCC results for 'temp_jumbo'. There are 494973 rows in 14559 pages for object 'temp_jumbo'. DBCC results for 'DOMB_1RK'. There are 0 rows in 1 pages for object 'DOMB_1RK'. DBCC results for 'michaelfor007'. There are 2189 rows in 23 pages for object 'michaelfor007'. DBCC results for 'SW_ORDER_FILLRATE_DL'. There are 704131 rows in 42479 pages for object 'SW_ORDER_FILLRATE_DL'. DBCC results for 'Sales_History_2005'. There are 706373 rows in 141280 pages for object 'Sales_History_2005'. DBCC results for 'DOMB_1RL'. There are 0 rows in 1 pages for object 'DOMB_1RL'. DBCC results for 'SOLD_SKUS_DL'. There are 543293 rows in 1740 pages for object 'SOLD_SKUS_DL'. DBCC results for 'DOMB_OUT'. There are 317 rows in 16 pages for object 'DOMB_OUT'. DBCC results for 'DOMC_PICK_TYPE'. There are 158525 rows in 2791 pages for object 'DOMC_PICK_TYPE'. DBCC results for 'DOMB_1TF'. There are 0 rows in 1 pages for object 'DOMB_1TF'. DBCC results for 'LUC_DAILY_FLASH_SALES_60DAYS'. There are 13100 rows in 252 pages for object 'LUC_DAILY_FLASH_SALES_60DAYS'. DBCC results for 'weekly_subclass_TOP10'. There are 263 rows in 8 pages for object 'weekly_subclass_TOP10'. DBCC results for 'DW_COFILLRATE_DL_PM'. There are 80 rows in 3 pages for object 'DW_COFILLRATE_DL_PM'. DBCC results for 'CURRENCY_CAD_USD'. There are 701 rows in 7 pages for object 'CURRENCY_CAD_USD'. DBCC results for 'LUC_SALES_ORDERDETAIL_2004'. There are 688727 rows in 27611 pages for object 'LUC_SALES_ORDERDETAIL_2004'. DBCC results for 'WEEKLYS_SUBCLASS_SALESly'. There are 269906 rows in 8188 pages for object 'WEEKLYS_SUBCLASS_SALESly'. DBCC results for 'Luc_47Skus_Top100_Step1'. There are 3597 rows in 164 pages for object 'Luc_47Skus_Top100_Step1'. DBCC results for 'DOMB_1TU'. There are 0 rows in 1 pages for object 'DOMB_1TU'. DBCC results for 'PROD_COMP_SKULIST'. There are 12219 rows in 121 pages for object 'PROD_COMP_SKULIST'. DBCC results for 'LUC_DAILY_FLASH_SALES_YESTERDAY'. There are 326 rows in 8 pages for object 'LUC_DAILY_FLASH_SALES_YESTERDAY'. DBCC results for 'WEEKLY_SUBCLASS_TOP20QTD'. There are 290 rows in 10 pages for object 'WEEKLY_SUBCLASS_TOP20QTD'. DBCC results for 'CO_DTL_DL_CA'. There are 554 rows in 14 pages for object 'CO_DTL_DL_CA'. DBCC results for 'DOMD1_PICK_TYPE'. There are 158783 rows in 2895 pages for object 'DOMD1_PICK_TYPE'. DBCC results for 'LUC_INVOICEDETAIL_2004'. There are 732349 rows in 61395 pages for object 'LUC_INVOICEDETAIL_2004'. DBCC results for 'DOMB_1W1'. There are 0 rows in 1 pages for object 'DOMB_1W1'. DBCC results for 'LUC_DAILY_FLASH_SALES_WEEKEND'. There are 0 rows in 13 pages for object 'LUC_DAILY_FLASH_SALES_WEEKEND'. DBCC results for 'Sales_Hist_Part_2004'. There are 722121 rows in 144430 pages for object 'Sales_Hist_Part_2004'. DBCC results for 'Luc_47Skus_Top100_Sku_Avgcost_Step1'. There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_Avgcost_Step1'. DBCC results for 'swidziun.victory$'. There are 492 rows in 8 pages for object 'swidziun.victory$'. DBCC results for 'DOMB_1W4'. There are 0 rows in 1 pages for object 'DOMB_1W4'. DBCC results for 'mlehn.MLEHN_675_ADDRESS'. There are 642 rows in 3 pages for object 'mlehn.MLEHN_675_ADDRESS'. DBCC results for 'weekly_subclass_TOP10_RESALE'. There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_RESALE'. DBCC results for 'cradtke.cr_intl_test2'. There are 28062 rows in 939 pages for object 'cradtke.cr_intl_test2'. DBCC results for 'Sales_History_2004'. There are 722121 rows in 144431 pages for object 'Sales_History_2004'. DBCC results for 'Weekly_Subclass_Forecast'. There are 2652 rows in 51 pages for object 'Weekly_Subclass_Forecast'. DBCC results for 'DOMB_1W5'. There are 0 rows in 1 pages for object 'DOMB_1W5'. DBCC results for 'ML_675_ADDR_MISS'. There are 24 rows in 2 pages for object 'ML_675_ADDR_MISS'. DBCC results for 'swidziun.UPLOAD$'. There are 40 rows in 1 pages for object 'swidziun.UPLOAD$'. DBCC results for 'DOM_BOL_S1'. There are 366531 rows in 10488 pages for object 'DOM_BOL_S1'. DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED'. There are 94017 rows in 2946 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED'. DBCC results for 'SW_DS_BOOKED_ECP_PRISM_FINAL'. There are 8 rows in 2 pages for object 'SW_DS_BOOKED_ECP_PRISM_FINAL'. DBCC results for 'DOMB_SUMRRATE'. There are 0 rows in 1 pages for object 'DOMB_SUMRRATE'. DBCC results for 'mlehn.MLEHN_925_ADDRESS'. There are 642 rows in 3 pages for object 'mlehn.MLEHN_925_ADDRESS'. DBCC results for 'DANVILLE_TO_OUT'. There are 10570 rows in 183 pages for object 'DANVILLE_TO_OUT'. DBCC results for 'ECP_MARKET_SEGMENTS'. There are 40 rows in 1 pages for object 'ECP_MARKET_SEGMENTS'. DBCC results for 'Luc_47Skus_Top100_Sku_AvgCost'. There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_AvgCost'. DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'. There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'. DBCC results for 'DOMB_1TN'. There are 0 rows in 1 pages for object 'DOMB_1TN'. DBCC results for 'ML_925_ADDR_MISS'. There are 88 rows in 4 pages for object 'ML_925_ADDR_MISS'. DBCC results for 'weekly_subclass_TOP10_ALL'. There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_ALL'. DBCC results for 'SW_DS_MTD_ECP_PRISM_FINAL'. There are 10 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM_FINAL'. DBCC results for 'Weekly_Subclass_Cancellation'. There are 15991 rows in 799 pages for object 'Weekly_Subclass_Cancellation'. DBCC results for 'ML_FAX_PMT_par'. There are 6785 rows in 108 pages for object 'ML_FAX_PMT_par'. DBCC results for 'LUC_ADHOC_SUBCLASS_04'. There are 132823 rows in 4585 pages for object 'LUC_ADHOC_SUBCLASS_04'. DBCC results for 'SALES_YESTERDAY'. There are 1738 rows in 290 pages for object 'SALES_YESTERDAY'. DBCC results for 'Luc_Top20_Invoices_Units_Step1'. There are 123944 rows in 3756 pages for object 'Luc_Top20_Invoices_Units_Step1'. DBCC results for 'SW_DS_BACKLOG1_ECP_PRISM'. There are 224 rows in 4 pages for object 'SW_DS_BACKLOG1_ECP_PRISM'. DBCC results for 'FREIGHT_FOR68'. There are 16 rows in 1 pages for object 'FREIGHT_FOR68'. DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'. There are 8806 rows in 152 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'. DBCC results for 'DOMB_LOWEST_SUM_RATE'. There are 0 rows in 1 pages for object 'DOMB_LOWEST_SUM_RATE'. DBCC results for 'ML_FAX_FG09_Fg10_final'. There are 444 rows in 6 pages for object 'ML_FAX_FG09_Fg10_final'. DBCC results for 'DOMB_1CI'. There are 0 rows in 1 pages for object 'DOMB_1CI'. DBCC results for 'temp_stan_cost_m2_lb'. There are 181694 rows in 1932 pages for object 'temp_stan_cost_m2_lb'. DBCC results for 'ml_FAX_pmt_par_FINAL'. There are 615 rows in 7 pages for object 'ml_FAX_pmt_par_FINAL'. DBCC results for 'SALES_DATA_2006_2007'. There are 0 rows in 1 pages for object 'SALES_DATA_2006_2007'. DBCC results for 'Weekly_Sales_Sublcass_top20_bookings'. There are 283 rows in 8 pages for object 'Weekly_Sales_Sublcass_top20_bookings'. DBCC results for 'SALES2006_REPORT_1'. There are 558623 rows in 13303 pages for object 'SALES2006_REPORT_1'. DBCC results for 'DANVILLE_TO_RDCW1'. There are 249 rows in 5 pages for object 'DANVILLE_TO_RDCW1'. DBCC results for 'Luc_Top20_Invoices_Units_Step2'. There are 123944 rows in 4274 pages for object 'Luc_Top20_Invoices_Units_Step2'. DBCC results for 'SW_DS_BACKLOG_ECP_PRISM'. There are 10 rows in 2 pages for object 'SW_DS_BACKLOG_ECP_PRISM'. DBCC results for 'cr_expense_data'. There are 74184 rows in 5268 pages for object 'cr_expense_data'. DBCC results for 'SW_DS_MTDLY_ECP_PRISM_FINAL'. There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM_FINAL'. DBCC results for 'Weekly_Subclass_Cancellation_Sum'. There are 622 rows in 12 pages for object 'Weekly_Subclass_Cancellation_Sum'. DBCC results for 'mlehn.MLEHN_PMT_ADDRESS'. There are 63 rows in 1 pages for object 'mlehn.MLEHN_PMT_ADDRESS'. DBCC results for 'weekly_sale_lytop20qtd'. There are 293 rows in 10 pages for object 'weekly_sale_lytop20qtd'. DBCC results for 'SW_FOR10'. There are 100085 rows in 1934 pages for object 'SW_FOR10'. DBCC results for 'Luc_top20_Invoices_Units_Step3'. There are 29017 rows in 1382 pages for object 'Luc_top20_Invoices_Units_Step3'. DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'. There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'. DBCC results for 'SW_DS_QTD_ECP_PRISM_FINAL'. There are 12 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM_FINAL'. DBCC results for 'ML_FAX_FG09_Fg10'. There are 3587 rows in 54 pages for object 'ML_FAX_FG09_Fg10'. DBCC results for 'DOMC_MASTERRATER'. There are 1593 rows in 35 pages for object 'DOMC_MASTERRATER'. DBCC results for 'DOM_BOL_S16A'. There are 13785 rows in 657 pages for object 'DOM_BOL_S16A'. DBCC results for 'DOMB_LOCATIONS'. There are 15 rows in 1 pages for object 'DOMB_LOCATIONS'. DBCC results for 'ML_PMT_ADDR_MISS'. There are 126 rows in 5 pages for object 'ML_PMT_ADDR_MISS'. DBCC results for 'LEmond.Danville_Rancho$'. There are 191 rows in 17 pages for object 'LEmond.Danville_Rancho$'. DBCC results for 'Luc_Top20_Invoices_Units_Sum_Total'. There are 20 rows in 1 pages for object 'Luc_Top20_Invoices_Units_Sum_Total'. DBCC results for 'SW_DS_MTD_ECP_PRISM'. There are 11 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM'. DBCC results for 'SW_DS_QTDLY_ECP_PRISM_FINAL'. There are 10 rows in 1 pages for object 'SW_DS_QTDLY_ECP_PRISM_FINAL'. DBCC results for 'TEMP_W4'. There are 307 rows in 10 pages for object 'TEMP_W4'. DBCC results for 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'. There are 81232 rows in 5084 pages for object 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'. DBCC results for 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'. There are 3315 rows in 30 pages for object 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'. DBCC results for 'DOM_BOL_S16B'. There are 13785 rows in 657 pages for object 'DOM_BOL_S16B'. DBCC results for 'VP_DETAIL_DL_TEMP'. There are 67047 rows in 988 pages for object 'VP_DETAIL_DL_TEMP'. DBCC results for 'DOM_JUMBO_BOL_TOT'. There are 92 rows in 1 pages for object 'DOM_JUMBO_BOL_TOT'. DBCC results for 'ML_FAX_ALL'. There are 14999 rows in 256 pages for object 'ML_FAX_ALL'. DBCC results for 'Luc_Top20_Report'. There are 20 rows in 1 pages for object 'Luc_Top20_Report'. DBCC results for 'SW_DS_MTDLY_ECP_PRISM'. There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM'. DBCC results for 'SW_DS_YTD_ECP_PRISM_FINAL'. There are 12 rows in 2 pages for object 'SW_DS_YTD_ECP_PRISM_FINAL'. DBCC results for 'TEMP_W41'. There are 446 rows in 14 pages for object 'TEMP_W41'. DBCC results for 'DOMC_WHSE_RANK'. There are 1 rows in 1 pages for object 'DOMC_WHSE_RANK'. DBCC results for 'WEEKLY_SUBCLASS_CANCEL_CHART'. There are 432 rows in 4 pages for object 'WEEKLY_SUBCLASS_CANCEL_CHART'. DBCC results for 'FPR101_Compare_Report'. There are 68426 rows in 22814 pages for object 'FPR101_Compare_Report'. DBCC results for 'RM_JANUARY_2007'. There are 7563 rows in 281 pages for object 'RM_JANUARY_2007'. DBCC results for 'WEEKLY_SUBCLASS_BF_CAN'. There are 2343 rows in 18 pages for object 'WEEKLY_SUBCLASS_BF_CAN'. DBCC results for 'SW_DS_YTDLY_ECP_PRISM_FINAL'. There are 11 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM_FINAL'. DBCC results for 'Weekly_Subclass_SalesChart'. There are 224 rows in 5 pages for object 'Weekly_Subclass_SalesChart'. DBCC results for 'FPR101_Compare_Report_Final'. There are 68426 rows in 9885 pages for object 'FPR101_Compare_Report_Final'. DBCC results for 'ML_FAX_aLL_final'. There are 231 rows in 7 pages for object 'ML_FAX_aLL_final'. DBCC results for 'Temp_Booking_dl'. There are 166084 rows in 6681 pages for object 'Temp_Booking_dl'. DBCC results for 'TEMP_W411'. There are 454 rows in 15 pages for object 'TEMP_W411'. DBCC results for 'Value_Test_Freight_Data1_BolSum'. There are 51332 rows in 634 pages for object 'Value_Test_Freight_Data1_BolSum'. DBCC results for 'Archive_Holds'. There are 9182 rows in 185 pages for object 'Archive_Holds'. DBCC results for 'TOP100_EDI'. There are 100 rows in 4 pages for object 'TOP100_EDI'. DBCC results for 'FREIGHT_FOR13_AVG_DISC'. There are 1 rows in 1 pages for object 'FREIGHT_FOR13_AVG_DISC'. DBCC results for 'LUC_ADHOC_SUBCLASS_04_Open'. There are 689 rows in 28 pages for object 'LUC_ADHOC_SUBCLASS_04_Open'. DBCC results for 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'. There are 83792 rows in 11976 pages for object 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'. DBCC results for 'LUC_adhoc_joe'. There are 84643 rows in 1924 pages for object 'LUC_adhoc_joe'. DBCC results for 'TEMP_W5'. There are 5814 rows in 183 pages for object 'TEMP_W5'. DBCC results for 'DW_Sales2006'. There are 299 rows in 2 pages for object 'DW_Sales2006'. DBCC results for 'INVENTORY_SUM'. There are 209426 rows in 2411 pages for object 'INVENTORY_SUM'. DBCC results for 'ORDERS_CODE9'. There are 453 rows in 17 pages for object 'ORDERS_CODE9'. DBCC results for 'SKU_ABC'. There are 17627 rows in 114 pages for object 'SKU_ABC'. DBCC results for 'Sales_History_2007'. There are 230381 rows in 46083 pages for object 'Sales_History_2007'. DBCC results for 'DOM_BOL_s5rk'. There are 367500 rows in 8971 pages for object 'DOM_BOL_s5rk'. DBCC results for 'RM_DECEMBER_2006'. There are 7262 rows in 269 pages for object 'RM_DECEMBER_2006'. DBCC results for 'DW_INVENTORY_AVAILABILITY'. There are 37253 rows in 217 pages for object 'DW_INVENTORY_AVAILABILITY'. DBCC results for 'temp_prod'. There are 29640 rows in 682 pages for object 'temp_prod'. DBCC results for 'Weekly_Subclass_Booking_Sum'. There are 391 rows in 11 pages for object 'Weekly_Subclass_Booking_Sum'. DBCC results for 'DOMC_BOL_FREIGHTCALC'. There are 1 rows in 1 pages for object 'DOMC_BOL_FREIGHTCALC'. DBCC results for 'INVENTORY_CANADIAN_LOCS'. There are 44 rows in 1 pages for object 'INVENTORY_CANADIAN_LOCS'. DBCC results for 'TEMP_SALES_2004_2007'. There are 391800 rows in 17811 pages for object 'TEMP_SALES_2004_2007'. DBCC results for 'FREIGHT_MINCHG'. There are 1 rows in 1 pages for object 'FREIGHT_MINCHG'. DBCC results for 'LUC_DAILY_FLASH_CANCEL'. There are 20882 rows in 280 pages for object 'LUC_DAILY_FLASH_CANCEL'. DBCC results for 'FRM10'. There are 183488 rows in 6335 pages for object 'FRM10'. DBCC results for 'DOMB_NUMDAYS'. There are 1 rows in 1 pages for object 'DOMB_NUMDAYS'. DBCC results for 'FREIGHT_WHSE'. There are 15 rows in 1 pages for object 'FREIGHT_WHSE'. DBCC results for 'SW_DS_QTDLY_ECP_PRISM'. There are 11 rows in 2 pages for object 'SW_DS_QTDLY_ECP_PRISM'. DBCC results for 'ml_cancel_dollar_reason_desc'. There are 1723 rows in 31 pages for object 'ml_cancel_dollar_reason_desc'. DBCC results for 'Temp_can_dl'. There are 7530 rows in 163 pages for object 'Temp_can_dl'. DBCC results for 'mlehn.MLEHN_FG09_FG10_ADDRESS'. There are 643 rows in 3 pages for object 'mlehn.MLEHN_FG09_FG10_ADDRESS'. DBCC results for 'INVENTORY_CANADIAN_EXRATE'. There are 1 rows in 1 pages for object 'INVENTORY_CANADIAN_EXRATE'. DBCC results for 'Luc_Top20_Step1'. There are 132991 rows in 2342 pages for object 'Luc_Top20_Step1'. DBCC results for 'DOM_BOL_MAR'. There are 122100 rows in 4218 pages for object 'DOM_BOL_MAR'. DBCC results for 'cr_expense_group'. There are 28 rows in 1 pages for object 'cr_expense_group'. DBCC results for 'SHIPPING_INFO_SHELDON'. There are 9706 rows in 157 pages for object 'SHIPPING_INFO_SHELDON'. DBCC results for 'SW_DS_QTD_ECP_PRISM'. There are 13 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM'. DBCC results for 'Calendar_2007'. There are 365 rows in 3 pages for object 'Calendar_2007'. DBCC results for 'ML_fg09_fg10_ADDR_MISS'. There are 2 rows in 1 pages for object 'ML_fg09_fg10_ADDR_MISS'. DBCC results for 'LUC_Top20_Step2'. There are 2465 rows in 42 pages for object 'LUC_Top20_Step2'. DBCC results for 'LEmond.Sku_Top20$'. There are 45 rows in 1 pages for object 'LEmond.Sku_Top20$'. DBCC results for 'FDP05_all'. There are 3714 rows in 39 pages for object 'FDP05_all'. DBCC results for 'DOMB_DATES'. There are 1 rows in 1 pages for object 'DOMB_DATES'. DBCC results for 'LUC_DAILY_FLASH_INVENTORY'. There are 9690641 rows in 364196 pages for object 'LUC_DAILY_FLASH_INVENTORY'. DBCC results for 'DOM_BOL_S9W1'. There are 367500 rows in 18388 pages for object 'DOM_BOL_S9W1'. DBCC results for 'Orders_Code9_Report'. There are 453 rows in 10 pages for object 'Orders_Code9_Report'. DBCC results for 'SW_DS_YTD_ECP_PRISM'. There are 13 rows in 1 pages for object 'SW_DS_YTD_ECP_PRISM'. DBCC results for 'ML_XPDEX_Sold_to_prices'. There are 0 rows in 1 pages for object 'ML_XPDEX_Sold_to_prices'. DBCC results for 'cradtke.cr_sdm_inv'. There are 14780 rows in 296 pages for object 'cradtke.cr_sdm_inv'. DBCC results for 'cr_sdm_combined'. There are 28296 rows in 838 pages for object 'cr_sdm_combined'. DBCC results for 'Open_Orders_Status_10_Tape_Film'. There are 3313 rows in 165 pages for object 'Open_Orders_Status_10_Tape_Film'. DBCC results for 'LEmond.Luc_47Skus_Top100'. There are 100 rows in 3 pages for object 'LEmond.Luc_47Skus_Top100'. DBCC results for 'Open_Order_Pastdue_Report'. There are 3008 rows in 150 pages for object 'Open_Order_Pastdue_Report'. DBCC results for 'SW_DS_YTDLY_ECP_PRISM'. There are 12 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM'. DBCC results for 'SE_CUSTOMERS_M'. There are 3 rows in 1 pages for object 'SE_CUSTOMERS_M'. DBCC results for 'Open_Order_Report'. There are 11686 rows in 532 pages for object 'Open_Order_Report'. DBCC results for 'SW_DS_FINAL_SUM_ECP'. There are 17 rows in 2 pages for object 'SW_DS_FINAL_SUM_ECP'. DBCC results for 'TEST_bin'. There are 2863 rows in 40 pages for object 'TEST_bin'. DBCC results for 'SKU_AVGWGHTSUBC'. There are 39 rows in 1 pages for object 'SKU_AVGWGHTSUBC'. DBCC results for 'cr_sdm_item'. There are 38065 rows in 1530 pages for object 'cr_sdm_item'. DBCC results for 'Open_Schedules_Query'. There are 2358 rows in 37 pages for object 'Open_Schedules_Query'. DBCC results for 'cr_sdm_prodgrp_invsls'. There are 23300 rows in 207 pages for object 'cr_sdm_prodgrp_invsls'. DBCC results for 'Luc_47Skus_Top100_Skulist'. There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Skulist'. DBCC results for 'LJ_FISCAL_DATE'. There are 1 rows in 1 pages for object 'LJ_FISCAL_DATE'. DBCC results for 'LUC_DAILY_FLASH_CANCEL_SUM'. There are 2827 rows in 222 pages for object 'LUC_DAILY_FLASH_CANCEL_SUM'. DBCC results for 'temp_sh2'. There are 171165 rows in 2063 pages for object 'temp_sh2'. DBCC results for 'DOMA_INVENTORY'. There are 23816 rows in 505 pages for object 'DOMA_INVENTORY'. DBCC results for 'cr_sdm_orhdr'. There are 19793 rows in 2234 pages for object 'cr_sdm_orhdr'. DBCC results for 'SW_DS_YESTERDAY_FLEX'. There are 7 rows in 2 pages for object 'SW_DS_YESTERDAY_FLEX'. DBCC results for 'ML_CANCELLATION'. There are 1495 rows in 61 pages for object 'ML_CANCELLATION'. DBCC results for 'Sales_History_Driver'. There are 816914 rows in 163383 pages for object 'Sales_History_Driver'. DBCC results for 'SW_DS_BOOKED_ECP_PRISM'. There are 8 rows in 1 pages for object 'SW_DS_BOOKED_ECP_PRISM'. DBCC results for 'cr_sdm_ordet'. There are 30303 rows in 2339 pages for object 'cr_sdm_ordet'. DBCC results for 'SW_DS_MTD_FLEX'. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0. There are 10 rows in 2 pages for object 'SW_DS_MTD_FLEX'. DBCC results for 'Claim_Weekly'. There are 18796 rows in 227 pages for object 'Claim_Weekly'. DBCC results for 'LUC_APRIL2007'. There are 4080 rows in 51 pages for object 'LUC_APRIL2007'. DBCC results for 'DOMB_MINORDDATE'. There are 1 rows in 1 pages for object 'DOMB_MINORDDATE'. DBCC results for 'cr_openord_test'. There are 1170 rows in 16 pages for object 'cr_openord_test'. DBCC results for 'cr_sdm_cust1'. There are 4417 rows in 108 pages for object 'cr_sdm_cust1'. DBCC results for 'asp_data'. There are 325752 rows in 23268 pages for object 'asp_data'. DBCC results for 'ml_cancel_dollar'. There are 731 rows in 7 pages for object 'ml_cancel_dollar'. DBCC results for 'GERRY_APRIL_2007'. There are 1915 rows in 37 pages for object 'GERRY_APRIL_2007'. DBCC results for 'DOMA_INVENTORY_SUM'. There are 7408 rows in 48 pages for object 'DOMA_INVENTORY_SUM'. DBCC results for 'CLAIMS_AUDIT_TRAIL'. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0. Server: Msg 2537, Level 16, State 1, Line
I have a report with a fixed header that works properly when the query returns results (or fixedheader = false). However, when the result set is empty, I get tenacious client-side "object required" errors. Obviously I can either turn the fixedheaders off or disable debugging in IE, but is there a Microsoft fix for this problem?
I have a user who uses the sql variant data type. Currently the database he uses is read only and he has noticed a lot of "garbage" in the column in the last few days. A dbcc shows no corruption and the user is following the rules of the sql variant data type as far as we know. One last thing, he never had this problem on AS 2000.
config: :confused: SQL 2000 SP3 on Windows Server 2003
Yesterday, one of the computers on the network of our SQL server experienced a connection failure while using two specific jobs in a table containing assignments for jobs. The data interaction occurs from a Data Access Page, and from what I've learned, the nature of a DAP is such that the client not only connects to the web server but actually also establishes a direct connection to the SQL Server (we use a backend of MS SQL Server 2003). The data is still inside the tables, but on the Data Access Page, any data that was opened during the connection failure does not show up anymore from any computer.
My guess is that there was corruption of some sort on another layer beneath the actual data layer that cannot be accessed directly or viewed. To remedy this problem, I am going to try to recreate all affected records and rebuild all table ID ties manually with append and update queries. Does anyone know the actual problem or corruption that occurs during a connection failure? Is there a way to access the affected layer(s) and undo the corruption or remedy the affect so the records can be used? Is the problem with the SQL Data itself or on a layer with MS Access/MS DAP?
This data is very important and needs to be used today and was supposed to be used yesterday. If anyone could help me in this matter or provide a better way to undo the supposed corruption, it would be greatly appreciated :)!
thanks in advance, mellamokb
PS - I don't know if this makes a difference, but other data has been changed in the same database/tables since the connection failure, so a complete reversion back to the system at that point in time would mean loss of other updated data.
Hi, I use SQL Server 2000 as a backend database for my Access Front end. It has been working fine for months with no problems. This morning I arrived in work to find a problem with a table called "TimeSheets". If I try to access the table through Access I get an ODBC timeout error. Likewise, if I open the table in Enterprise manager, it opens fine, but any sorts or if I try to go to the last record, it returns the following error: "[Microsoft][ODBC SQL Server Driver] Timout expired".
So I tried to query the table in SQL Query Analyzer. Everytime it freezes on record 15,936. The table holds 17,643 records.
I tried running DBCC CHECKTABLE ('Timesheets'), and get the following message:
DBCC results for 'Timesheet - Item'. There are 17643 rows in 401 pages for object 'Timesheet - Item'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I can't see any error messages, but by now I'm reaching the limit of my knowledge of SQL Server.
So, can anybody please help me with this? Any suggestions why my table has apparently become corrupted? Any suggestions how I might fix it?
Dear group,if someone could give me an idea what is going on in one of ourdatabases, this would really really be helpful.We have two tables with around 2 / 3 million rows. These tables have nokey and no ID. (This major design flaw will be overcome in some laterversion of the application-software working on this DB but right now ihave to live with this).Now for the funny bit1) I open one window in the Query-Analyzer and write some code likeBegin transaction INSERT INTO TABLE COMMIT2) in another window i write "SELECT COUNT(*) from TABLE"If I perform the insert then afterwards select count(*) the row-countis incremented by two whereas the Insert-Statement said "1 row(s)modified.DBCC gives no errors.DBCC gives amount of rows 2 million rowsSelect count(*) on the same table gives 3 million rowsExporting the data, truncating the table re-importing data gives noresult, right now the DTS-status is 203 and the machine is "thinking".Is there any possibility to check the "integrity" of the table?This problem is on the production machine, but right now i am workingon a copy so it was propagated with backup / restore-mechanism.Any hint would be very helpfulThanks and GreetingsUli
All; I have 14 errors in one of my tables and I know that all of you would recomend to restore form back-up. But i dont know when this table was corrupted and also loosing even days work is not an option. Below is what i received from DBCC CHECKDB ------ I dont mind loosing some data as far as i know what they are. Any way to know what will be lost?? Or any other way to restore rather than form the backup.... =================================================================== DBCC results for 'Call_Events'. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341561), slot 21, text ID 120642207744 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341564), slot 53, text ID 120686379008 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 23, text ID 120684609536 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 27, text ID 120684806144 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 28, text ID 120684937216 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341869), slot 0, text ID 120729305088 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342598), slot 45, text ID 120850743296 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342677), slot 58, text ID 120895897600 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2073058421. The text, ntext, or image node at page (1:359535), slot 26, text ID 125433413632 is not referenced. There are 1108430 rows in 91674 pages for object 'Call_Events'. CHECKDB found 0 allocation errors and 14 consistency errors in table 'Call_Events' (object ID 2073058421).
Hello everyone, I am trying to implement two list boxes such that contents of one depends on selection in the other w/o reloading the page. I am using SqlDataSource object to retrieve data from SQL DB. When I am trying to write javascript for listbox population I run into an issue of not knowing which properties I have access to for SqlDataSource object. I need to know how many rows of information is there in the object and how to access that data. Can anyone advise on how would I do that, or direct me to a website that has a list of avalable properties?
hi, i have created a database where information on the web page is pulled out from the database. however i need to add javascript functionality to it. does anyone have any suggestions as to how i can achieve this and what is the best way to do it, eg, use dataview, gridview. if anyone thinks it would be easier for me to post up some of my code then i will upon request. thanks for any help given, it is much needed
I would like to know if someone has any idea on how to make a "<select></select>" tag hidden. for a textbox it's simply: <input type="hidden" id="textCustom2" name="textCustom2" value>. Is there such a thing for options? a javascript perharps?
Hi, I am trying to link to a page outside of reporting services from a report. I am using SQL Server 2005 Reporting Services [Standard Edition]. The hyperlink works if it is a straight URL, however, nothing happens if I modify it to use Javascript so I can open the link in a new window. I have found many posts on the web from others indicating it should be really easy, but I can not get the link to recognize ANY Javascript (also tried a basic alert with no luck).
The Javascript I am using is well formatted. I can place it into a test page and it runs fine. I can also RC and View Source on my report, grab the entire link, put it in a test page and it works fine. It just doesn't work from the report - ?
Here is the problem. I am trying to write this: strLink2 = "<a href='JavaScript:OpenFile(" & strFileName & ")'>" & strFileName & "</a>" to SQL and then return it to a datagrid when I want it.
Easy enough, and as such all is well except for the fact that the Javascript doesn't work. In the grid it gets written as JavaScript:OpenFile(myfile). I need to add the single quotes around the file name so it writes JavaScript:Open('myfile').
I now know many ways that do not work. Any help would be greatly appreciated.
I need to dispaly 'mm/dd/yyyy' on a text box(aspx page) by default. When the user enters the date(only numerics) in the text box it should take the date in that order. eg.. if the user enters 01012008 on that text box, it should display 01/01/2008, adding '/' by itself. if the user enters 12312008 on that text box, it should display 12/31/2008, adding '/' by itself. I am having tuff time,Can anyone, please provide the code for this solution.
I found an article on connecting SQL server using JavaScript. http://www.devarticles.com/c/a/JavaScript/Combining-North-Pole-with-South-Pole-JavaScript-with-SQL-Server-2000/
Do you people think it's possible? i try out the code already but something wrong with it. I just copy and paste it to a html file but it comes out with error. Do I miss out something? Thanks.
It works great. I'm able to open the window and target links back to the same open window. But what I can't do is keep that window on top above all of the other windows. That is without closing the newly opened window and reclicking another link.
Is there someway for me to set the focus to the newly opened window so it will always remain above all other windows? I know this can be done with javascript(Code below would do the trick) but I'm just not sure how to incorporate the scripts into reporting service.
var newwindow; function windowopen(url) { newwindow=window.open(url,'name','height=400,width=200'); if (window.focus) {newwindow.focus()}
I'm using reporting services actions to execute some javascript. My javascript is quite complicated. Thus I don't want to duplicated it on each item. I've created javascript function and wan't to execute it from actions. But I can't find the way how to include my javascript code into my reports. If there's way to include it for all reports generated on reporting services server - it works fine for me.
i have a problem with the rs 2005, using url access to call a report:
--------------------------- Error --------------------------- Error: 'RSClientController' is undefined
Calling a report from the reportmanager works. The rs2005 runs on a machine with a parallel installed rs2000.
I configured the virtual directory to machinename/reports2005 & machinename/reportserver2005.
When i debug the clientscript i see that he requests a "/ReportServer2005/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=9.00.1399.00&Name=Scripts.ReportViewer.js" and it seems that he doesn't get the jscript file.
I tried the solution with the axd-mapping, which an user posted here before but it didn't worked for me.
hi, iam thinking of changing my ajax slideshow so that it gets the data from the databse. currently i am finding it hard to add text functianlity the way i want with the slide show. what my query is, that if i to using a datalist can i add javasscript functionality to the data being retrived. for example, currently i have written some javascript so that a series of text is diplayed one after the other in a sequence from just one button click. so if im pulling data out of a databse can i still add this javascript functionality to it? i hope this makes sense, if it doesnt then i am willing to elaborate. please can any one offer any advice or examples or any suggestions on how i can do this. any help is much appricated as i am struggling to find a solution as i orinally wanted to be able to add this javascript functionality with the play button of the slide show but i couldnt find a solution.also i think its better to use some kind of database as i can use the editing funtions visual web developer offers thank you
Can anyone help with the proper syntax to use to populate a JavaScript array using values from an SQL database. I tried doing the following with no results:
