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
I am trying to migrate our Portals database from SQL2000 to SQL2005, but I received "SQL Type Variant Data" error during the data migration with some database. Can anyone help me with this?
Thanks,
Jay
In the following code snippet, the stored procedure executes up to the
iRet = vciSqlCommand.ExecuteNonQuery();
command and fails with error:
System.Data.SqlClient.SqlException: Incorrect syntax near 'value'.
That would point to the
" = @data_Param where
section.
So what is the proper syntax?
Code Snippet
SqlParameter data_Param = new SqlParameter("@data_Param", SqlDbType.Variant);
SqlCommand vciSqlCommand = new SqlCommand();
switch ((vcidatatype)FieldDef.ivcidatatype)
{ // read in the binary data!!!!!!
case vcidatatype.eENGUNITS: data_Param.Value = Encoding.ASCII.GetString(r.ReadBytes(FieldDef.iLen)); break;
case vcidatatype.eLANADR: data_Param.Value = r.ReadInt16(); break;
case vcidatatype.eBYTESIZE: data_Param.Value = r.ReadByte(); break;
case vcidatatype.eFLOATSIZE: data_Param.Value = r.ReadSingle(); break;
case vcidatatype.eINT32SIZE: data_Param.Value = r.ReadUInt32(); break;
case vcidatatype.eFILLERBYTES: r.ReadBytes(FieldDef.iLen); break; // eat up empty bytes
default: FieldDef.ivcidatatype = (Int32)vcidatatype.eFILLERBYTES; break;
}
if (FieldDef.ivcidatatype != (Int32)vcidatatype.eFILLERBYTES)
{ // all but filler
vciSqlCommand.CommandText =
"update " + acPointType + "set " + FieldDef.sFldName +
" = @data_Param where VEC = " + acVECName +
" and name = " + acPointName;
vciSqlCommand.Connection = conn;
conn.Open();
iRet = vciSqlCommand.ExecuteNonQuery();
conn.Close();
I am trying to declare a global variable in a DTS package for passing the recordset to the next stage Active Script . After declaration of the Global Variable and selecting datatype of the variable as OTHER ( Variant ) , when I try to save the DTS Package changes , it throws a Type Mismatch Error .
:confused: Please help me out .
Thanx
Arnie .
Can anyone help on this?
In SQL 2005, I use a variant with XML type; it seems that its size is limited here. If I assign a big data to it, it appears not assigned at all. Here is the example:
Code Snippet
declare @xml xml
--cross two table to get many records returned, if nothing is abnormal, just cross more tables here
select * from master.sys.objects a, master.sys.objects b for xml RAW, ELEMENTS
set @xml=( select * from master.sys.objects a, master.sys.objects b for xml RAW, ELEMENTS )
select @xml
--no results here for var @xml
--use single table to get fewer records returned.
select * from master.sys.objects for xml RAW, ELEMENTS
set @xml=( select * from master.sys.objects for xml RAW, ELEMENTS )
select @xml
--results as normal.
Note:here I don't want to test SQL server, I just use XML type variant as oupput for a sproc, and come across the issue here.
Any reply will be appreciated!
Hi, I was wondering if there is a method (other than BULK INSERT) to insert a (C++) application level array into the database, I have a variant type array populated with values that I want to insert, perhaps using ADO objects in quick time!
When viewing a 6.5 table using ISQL or Enterprise Manager several fields on a few records appear empty.
The records, however, appear correctly populated when viewing them through Visual Studio data links (ODBC or OLEDB).
Any ideas ?
Paul,
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/
Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Hi,
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.
---------------------------------------------------------------------
Any help that you can provide me would be greatly appreciated.
Thanks,
Suler Abou
Hi,
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 @@TableName NVARCHAR(100)
DECLARE @@ColumnName NVARCHAR(100)
DECLARE @@ColumnType NVARCHAR(100)
DECLARE @@ColumnLengh FLOAT
DECLARE @@SQL NVARCHAR(1000)
DECLARE @@IsNullAble NVARCHAR(50)
PRINT 'ALTERING TABLE COLUMNS...'
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?
Thank you for reading downto here ;)
Take care all :)
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!
Linda
Hi paul,
Can you help me solve this issue? I do backups everyday.
Do you think dropping and restoring the DB will solve this issue?
---------------------------------------------------------------------
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
Hi all,I have a table called PTRANS with few columns (see create script below).I have created a view on top that this table VwTransaction (See below)I can now run this query without a problem:select * from dbo.VwTransactionwhereAssetNumber = '101001' andTransactionDate <= '7/1/2003'But when I create an index on the PTRANS table using the command below:CREATE INDEX IDX_PTRANS_CHL# ON PTRANS(CHL#)The same query that ran fine before, fails with the error:Server: Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted inan out-of-range datetime value.I can run the same query by commeting out the AssetNumber clause and itworks fine. I can also run the query commenting out the TransactionDatecolumn and it works fine. But when I have both the conditions in theWHERE clause, it gives me this error. Dropping the index solves theproblem.Can anyone tell me why an index would cause a query to fail?Thanks a lot in advance,AmirCREATE TABLE [PTRANS] ([CHL#] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[CHCENT] [numeric](2, 0) NOT NULL ,[CHYYMM] [numeric](4, 0) NOT NULL ,[CHDAY] [numeric](2, 0) NOT NULL ,[CHTC] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL) ON [PRIMARY]GOCREATE VIEW dbo.vwTransactionsASSELECT CONVERT(datetime, dbo.udf_AddDashes(REPLICATE('0', 2 -LEN(CHCENT)) + CONVERT(varchar, CHCENT) + REPLICATE('0', 4 -LEN(CHYYMM))+ CONVERT(varchar, CHYYMM) + REPLICATE('0', 2 -LEN(CHDAY)) + CONVERT(varchar, CHDAY)), 20) AS TransactionDate,CHL# AS AssetNumber,CHTC AS TransactionCodeFROM dbo.PTRANSWHERE (CHCENT <> 0) AND (CHTC <> 'RA')*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedAfter testing out the application i write on the local pc. I deploy it to the webserver to test it out. I get this error.
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
Notes: all pages that have this error either has a repeater or datagrid which load data when page loading.
At first I thought the problem is with the date, but then I can see
that some other pages that has datagrid ( that has a date field) work
just fine.
anyone having this problem before?? hopefully you guys can help.
Thanks,
Hi,
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?
Thanks a lot for any help
Colin
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
View 5 Replies View RelatedI 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.
View 1 Replies View RelatedHi,
I can populate a dataTable with type double (C#) of say '1055.01' however when I save these to the CE3.5 database using a float(CE3.5) I lose the decimal portion. The 'offending' code is:
this.court0TableAdapter1.Update(this.mycourtsDataSet1.Court0);
this.mycourtsDataSet1.AcceptChanges();
this.court0TableAdapter1.Fill(this.mycourtsDataSet1.Court0);
This did not happen with VS2005/CE3.01.
I have tried changing all references to decimal (or money in CE3.5) without luck.
I'm beginning to think that string may be the way to go!!!!!!!
Can someone shed some light on my problem.
Thanks,
Later:
It's necessary to update the datatable adapter as the 3.01 and 3.5 CE are not compatible.
We have some columns in a table where the date is stored as 19980101 (YYYYMMDD). The data type for this column is NUMBER(8) in Oracle.
I need to copy rows from Oracle to SQL Server using SSIS. I used the Data Conversion transformation editor to change it to DT_DATE, but the rows are not being inserted to the destination.
On Error, If I fail the component, then the error is :
There was an error with input column "ORDER_DATE_CONV" (1191) on input "OLE DB Destination Input" (29). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
Regards
RH
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 all .. I have a form that includes two textboxes (Date and Version) .. When I try to insert the record I get the following error message .. seems that something wrong with my coversion (Data type)"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated."
in my SQL database I have the date feild as datetime and the version as nvarchar(max)
this is the code in the vb page .. Can you please tell me how to solve this problem?Imports System.Data.SqlClient
Imports system.web.configuration
Partial Class Admin_emag_insert
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Record_DateTextBox.Text = DateTime.Now
End Sub
Protected Sub clearButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles clearButton.Click
Me.VersionTextBox.Text = ""
End Sub
Protected Sub addButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles addButton.Click
Dim objConnection As SqlConnection
Dim objDataCommand As SqlCommand
Dim ConnectionString As String
Dim record_date As Date
Dim version As String
Dim emagSQL As String
'save form values in variables
record_date = Record_DateTextBox.Text
version = VersionTextBox.Text
ConnectionString = WebConfigurationManager.ConnectionStrings("HRDBConnectionString").ConnectionString
'Create and open the connection
objConnection = New SqlConnection(ConnectionString)
objConnection.Open()
emagSQL = "Insert into E_Magazine (Record_Date, Version ) " & _
"values('" & record_date & "','" & version & "')"
'Create and execute the command
objDataCommand = New SqlCommand(emagSQL, objConnection)
objDataCommand.ExecuteNonQuery()
objConnection.Close()
AddMessage.Text = "A new emagazine was added successfully"
Me.VersionTextBox.Text = ""
End Sub
End Class
Hi,I would like to convert a dollar amount ($1,500) to represent Fifteenhundred dollars and 00/100 cents only for SQL reporting purposes. Isthis possible and can I incorporate the statement into an existingleft outer join query.Thanks in advance,Gavin
View 1 Replies View RelatedHi,
I have a user defined data type which is called DEmployeeName,
it's length is varchar(20), how do i change it into varchar(30) without droping it?
I'm using SQL server 2005.
Thanks in advance..
I have a field that is currently stored as the data type nvarchar(10), and all of the data in this field is in the format mm/dd/yyyy or NULL. I want to convert this field to the smalldatetime data type. Is this possible?
I've tried to use cast in the following way, (rsbirthday is the field name, panelists is the table), but to no avail.
SELECT rsbirthday CAST(rsbirthday AS smalldatetime)
FROM panelists
the error returned is "incorrect syntax near 'rsbirthday'.
I'm rather new to all things SQL, so I only have the vaguest idea of what I'm actually doing.
Thanks for the help!
update tblPact_2008_0307 set student_dob = '30/01/1996' where student_rcnumber = 1830when entering update date in format such as ddmmyyyyi know the sql query date format entered should be in mmddyyyy formatis there any way to change the date format entered to ddmmyyyy in sql query?
View 5 Replies View RelatedHi, I was wondering if there is a method (other than BULK INSERT) to insert a (C++) application level array into the database, I have a variant type array populated with values that I want to insert, possibly using ADO Objects, in quick time!
View 1 Replies View RelatedHi,
The table in SQL has column Availability Decimal (8,8)
Code in c# using sqlbulkcopy trying to insert values like 0.0000, 0.9999, 29.999 into the field Availability
we tried the datatype float , but it is converting values to scientific expressions€¦(eg: 8E-05) and the values displayed in reports are scientifc expressions which is not expected
we need to store values as is
Error:
base {System.SystemException} = {"The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column."}
"System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column. ---> System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column. ---> System.ArgumentException: Parameter value '1.0000' is out of range.
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
at MS.Internal.MS
COM.AggregateRealTimeDataToSQL.SqlHelper.InsertDataIntoAppServerAvailPerMinute(String data, String appName, Int32 dateID, Int32 timeID) in C:\VSTS\MXPS Shared Services\RealTimeMonitoring\AggregateRealTimeDataToSQL\SQLHelper.cs:line 269"
Code in C#
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnection, SqlBulkCopyOptions.Default);
DataRow dr;
DataTable dt = new DataTable();
DataColumn dc;
try
{
dc = dt.Columns.Add("Availability", typeof(decimal));
€¦.
dr["Availability"] = Convert.ToDecimal(s[2]); ------ I tried SqlDecimal
€¦€¦€¦.
}
bulkCopy.DestinationTableName = "dbo.[Tbl_Fact_App_Server_AvailPerMinute]";
bulkCopy.WriteToServer(dt);
thx
I am trying to use the Bulk Insert Task to load from a csv file. My final column is a bit that is nullable. My file is an ID column that is int, a date column that is mm/dd/yyy, then 20 columns that are real, and a final column that is bit. I've tried various combinations of codepage and datafiletype on my task component. When I have RAW with Char, I get the error included below. If I change to RAW/Native or codepage 1252, I don't have an issue with the bit; however, errors start generating on the ID and date columns.
I have tried various data type settings on my flat file connection, too. I have tried DT_BOOL and the integer datatypes. Nothing seems to work.
I hope someone can help me work through this.
Thanks in advance,
SK
SSIS package "Package3.dtsx" starting.
Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 24. Verify that the field terminator and row terminator are specified correctly.Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 23 (cancelled).".
Error: 0xC002F304 at Bulk Insert Task 1, Bulk Insert Task: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 24. Verify that the field terminator and row terminator are specified correctly.Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 23 (cancelled).".
Task failed: Bulk Insert Task 1
Task failed: Bulk Insert Task
Warning: 0x80019002 at Package3: The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package3.dtsx" finished: Failure.
Nz(variant [, valueifnull ] ) is the syntax.
If the value of variant isn't Null, then the Nz function returns the value of variant.
Can I return a custom value if the variant isnt null?
Advance thanks ....... My table is TimeSheet:----------------------------------- CREATE TABLE [dbo].[TimeSheet]( [autoid] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NOT NULL, [starttime] [datetime] NOT NULL, [endtime] [datetime] NOT NULL, [summary] [nvarchar](50) NOT NULL, [description] [nvarchar](50) NULL, [dtOfEntry] [datetime] NOT NULL, [Cancelled] [bit] NULL) ON [PRIMARY] My Query is------------------ insert into timesheet (UserId, StartTime,EndTime, Summary, Description,DtOfEntry) values (2, '19/04/2008 2:05:06 PM', '19/04/2008 2:05:06 PM', '66', '6666','19/04/2008 2:05:06 PM')i m not able to insert value Error Message is-------------------------Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated. can any body give any solution
View 5 Replies View RelatedHey, I have a big problem that i wanna search data from SQL by DateTime like thatselect * from test where recorddate='MyVariableWhichHoldDate'i use variable that holds Date info.i searched a lot infomation on net but there is no perfect solution. i know why this occur but there is no function to solve this problem. i used a lot of ways. it accept yyyy-mm-dd format but my variable format is dd-mm-yyyyy . is there any function for this problem? and any other solution.thanks for ur attentionregards
View 6 Replies View Related