Apparent Data Corruption In Table
Apr 17, 2007
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
View 4 Replies
ADVERTISEMENT
Jun 28, 2001
I have a database with a corrupt table and no matter what I do (dbcc's and rebuilding indexes), there are row fetch errors still occurring daily. My solution now is just to drop the table and recreate it.
Is it as simple as copying the data out of the original table, dropping the original table, and recreating the original table? What about the pointers to other pages? Referential integrety? Please give me a good reference for this subject or let me know. Thank you?
View 1 Replies
View Related
Oct 3, 2005
I get the following errors when I ran dbcc checkdb..
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13015). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13039). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 18099105, index ID 0: Page (1:13015) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 18099105, index ID 1. Page (1:12777) is missing a reference from previous page (1:12567). Possible chain linkage problem.
and
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 562101043, index ID 2. The high key value on page (1:1779) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:13072).
What does it mean and how can i resolve them....
Database went into suspect mode , is this the likely cause..
View 20 Replies
View Related
Jul 23, 2005
I have a table in my database called Users:CREATE TABLE [Users] ([UserID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Users_UserID]DEFAULT (newid()),[UserName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[password] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[EmailAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_ASNOT NULL ,[ValidFrom] [datetime] NOT NULL ,[ValidTo] [datetime] NULL ,[passwordSalt] [bigint] NOT NULL ,[FullName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[CreatorUserID] [uniqueidentifier] NOT NULL ,[DeletorUserID] [uniqueidentifier] NULL ,CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED([UserID],[]) ON [PRIMARY] ,CONSTRAINT [UX_Users_UserName] UNIQUE NONCLUSTERED([UserName]) ON [PRIMARY] ,CONSTRAINT [FK_Users_UsersCreator] FOREIGN KEY([CreatorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [FK_Users_UsersDeletor] FOREIGN KEY([DeletorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [CK_Users_Finished] CHECK ([ValidTo] is null and[DeletorUserID] is null or ((not([ValidTo] is null))) and((not([DeletorUserID] is null)))),CONSTRAINT [CK_Users_ValidDates] CHECK ([ValidFrom] <= [ValidTo])) ON [PRIMARY]GOIf you're looking at the Primary Key constraint above, you can probablyalready see the problem (this script was produced by Query Analyzer).If I try to get query analyzer to just script the PK, I get thefollowing error message:[SQL-DMO]The name '' is not a valid object identifier, or is not avalid format for this property or method.I've googled for this phrase, and cannot locate it. If I drop all ofthe constraints in my database, and reapply the constraints to Usersusing the following script:alter table Users add constraintDF_Users_UserID DEFAULT NEWID() FOR UserIDgoalter table Users add constraintPK_Users PRIMARY KEY(UserID) on [PRIMARY]goalter table Users add constraintUX_Users_UserName UNIQUE(UserName)goalter table Users add constraintCK_Users_ValidDates CHECK(ValidFrom <= ValidTo)goalter table Users add constraintCK_Users_Finished CHECK((ValidTo is null andDeletorUserID is null)or(not ValidTo is null andnot DeletorUserID is null))goalter table Users add constraintFK_Users_UsersCreator FOREIGN KEY(CreatorUserID)REFERENCES Users(UserID)goalter table Users add constraintFK_Users_UsersDeletor FOREIGN KEY(DeletorUserID)REFERENCES Users(UserID)goI *still* have this wierd PK. I've checked through both theINFORMATION_SCHEMA views and directly through the system tables, and sofar as they are concerned there is only a single column (UserID) actingas part of the PK.So, any ideas? It appears to be preventing us from setting upreplication. Thankfully, it also occurs in a restored backup of the DB,so I'll be able to reproduce/attempt fixes to my hearts content.Thanks,Damien
View 10 Replies
View Related
Jan 19, 2001
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 ?
View 1 Replies
View Related
May 6, 2008
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
View 8 Replies
View Related
Sep 21, 2007
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
View 2 Replies
View Related
Feb 10, 2008
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
View 5 Replies
View Related
Oct 5, 2000
Sql 7. SP 2
After renaming a table Table_tbl to Table_old
and vise-versa.
When selecting from Table_old (for yesterday's data)
I get errors stating that Page belongs to Table_tbl.
Any suggestions on how to successfully rename Old to New, etc.
And not have cross-linked data pages??
View 1 Replies
View Related
Apr 7, 2008
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 :)
View 4 Replies
View Related
Aug 23, 2005
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
View 4 Replies
View Related
Jun 13, 2007
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
View 11 Replies
View Related
Dec 14, 2005
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1513928615, index ID 0: Page (3:33709) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1513928615, index ID 0, page (3:33709), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 95 and 30.
DBCC results for 'Result'.
There are 41589306 rows in 660667 pages for object 'Result'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Result' (object ID 1513928615).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (LASAR2.dbo.Result ).
View 12 Replies
View Related
Sep 14, 2005
Dear group,we are running a SQL-Server Database which is about 30 GB large. Thepurpose of this database is to contain periodic data from automaticdevices which insert values into some tables.Unfortunately most of these tables don't have a key (and a key can onlybe introduced when the application programmers have changed theirsoftware). Tables have this structuredeviceno timestamp datawhere we expect for every device and timestamp one row of data.In the ongoing operation it happens that the index of this large tablegets corrupted and a select from this table yields 2 rows for somedevices.In fact a select "SELECT DEVICENO, TIMESTAMP, COUNT(*) FROM TABLE GROUPBY DEVICENO, TIMESTAMP HAVING COUNT(*) > 1" returns lots of data.After rebuild of the indexes the table is "clean" again.What could cause the index corruption ?Missing key?Faulty application program ?a combination of both ?How can i prevent this from happening again, as long as there is noupdated database / application ?I'd be grateful for any useful commentRegardsUli
View 14 Replies
View Related
May 12, 2004
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
View 2 Replies
View Related
Jan 18, 2006
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.
View 4 Replies
View Related
Jul 23, 2005
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 Related
Jan 1, 2008
I have a SQL Server 2000 database that had its data corrupted. Any text field, usually varchar(50) or greater, had most of its text replaced with a script HTML tag pointing to a w.js file on rnmb.net. I think the update came in through a website because only one of the databases on the server had its data corrupted. Has anyone heard of this before? I can't find any information on this corruption on the internet because when I do a search for the exact script, it returns other websites that have been corrupted by it.
View 1 Replies
View Related
Dec 17, 2007
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).
View 3 Replies
View Related
Mar 15, 2006
I have an old application running on SQL Server 6.5 (6.50.416) that has a number of internal issues - inability to dump the transaction logs (would dump 9gb out of a 10gb datbase everytime regardless of truncating the logs), transaction log size of 0 even though 700mb allocated, very long DBCC's (though they complete properly).
I am trying to salvage the database by using DTS to copy out the schema, data, sp's, etc. into a new database.
I have the conversion running without error. Data usage goes from almost 10gb down to under 3gb and the transaction logs are now working.
However, when I use DBCC checkdb on the new database, I get the following (just a small sample):
Checking 524528902
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25930 row#=10); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25930 row#=10 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25941 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25941 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x1b20a800, pageno = 25941, status = 0xD, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1794. The offset should be 1384.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25967 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25967 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x22ab9000, pageno = 25967, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1667. The offset should be 1345.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26146 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26146 row#=0 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26151 row#=5); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26151 row#=5 computed row length=521 row length on page=520
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26163 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26163 row#=0 computed row length=546 row length on page=545
Msg 2596, Level 16, State 1
Page pointer = 0x218ba800, pageno = 26163, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1387. The offset should be 577.
etc...
The errors occur only on 3 specific user tables, and are consistent each time I try the conversion. Same exact page numbers and offsets (page pointers are of course different). I do not get any DBCC errors on the original DB at all. I can do select's on the tables without issue, and they seem to have the correct amount of data (did row counts and sums of various columns)
Any insight into what might be causing this or what the actual error is would be welcome.
Thanks,
Brett
View 7 Replies
View Related
Feb 12, 2003
We are experiencing an intermittent locking or hanging problem on our SQL Server (at the application level on the clients) and it has gotten worse very recently.
I haven't seen any processes that appear to be locked yet but I noticed that we don't have a lot of space available (the database is 1.4 gigs and we have about 245 megs available).
If this is inadequate disk space, could that be causing an apparent locking problem?
Thanks in advance for any help.
View 3 Replies
View Related
Jun 14, 2004
Hi,
I hava a JAVA application that updates a SQL2000 (SP3a)database.
The application handles different types of "jobs" which effectively update the DB.
One job in particular appears to block all subsequent jobs. It comprises of a large amount of inserts/updates in a single transaction. This is necessary as it is an "all or nothing" scenario - so we cannot break the transaction into smaller ones. The transaction appears to succeed as it reaches the COMMIT TRAN statement without error.
However the records do not get written to the database.
EM indicates a large number of locks held on the tables accessed by the transaction and these do not get released.
Using the SP sp_blocker_pss80, the blocking SPID has a waittime of 0 and a waittype of 0x0000 - the lastwaittype is WRITELOG and its status is AWAITING COMMAND
I am using MS SQLSERVER JDBC Driver SP2 (considering using jTDS)
I have tried
- increasing Transaction Log size
- Moving Transaction Log to a separate Disk
- Reducing Isolation Mode to Read Uncommitted
- Set AutoCOMMIT to true
- set Close Cursor on COMMIT
- set SelectMethod to Direct - (we use Cursor by default)
None of these have succeeded in fixing the issue.
The job will succeed if it is the first/only job to access the database.
But if another job precedes it - then the blocking occurs.
I have verified that the preceding job only holds shared dataabase locks
before the blocking job is run.
Each job will use its own JDBC connections to access the database for reading
purposes, but all of the writing goes through the blocking SPID.
Any ideas?
Thanks, Liam
View 4 Replies
View Related
Sep 1, 2007
SQL Server 2005 SP2 (build 3054)Consider the following scenario:- A complex multi-statement table valued function is created. Let's callit dbo.tfFunc(@Param1, @Param2)- A SELECT statement is executed, that calls the above function twice,each time with a different set of parameters. In pseudocode:SELECT <column list>FROM dbo.tfFunc(1, 2) AS f1<some JOIN operatordbo.tfFunc(3, 4) AS f2ON f1.col = f2.colINNER JOIN dbo.Table1 AS t1ON ...etc.The exact statement is probably irrelevant, as long as the same table-valued function is called twice (I have observed the issue in two verydifferent statements calling the same function). The statement isexecuted in a SNAPSHOT isolation level transaction, although this mayalso be irrelevant.- The statement continues executing for a long time. If sp_who2 is run atthat time, the following row is returned for the statement connection(only relevant columns are shown):SPIDStatusBlkByCommandCPUTimeDiskIOLastBatch63 SUSPENDED63SELECT2928268308/31 18:17:37The statement appears to be blocked by itself. If sp_lock is run at thattime, the following rows are returned:spiddbidObjIdIndIdTypeResourceModeStatus63213166246410TABSch-SGRANT63213166246410TABSch-MWAITIt appears that SQL Server waits indefinitely trying to obtain a schema-modification lock on a resource which already has a schema-stability lockplaced on it by the same connection.The following is pure speculation, but it seems reasonable to assume thatthe server has materialized the result of the first call to the functionusing a temporary table in tempdb, and is trying to materialize theresult of the second call using the same temporary table (same ObjId insp_lock results).I do not know why this does not cause a deadlock error.Unfortunately, I do not have a simple repro script for this. The actualcode is rather complex. While I can devise a workaround, this does looklike a bug. I am posting it here before submitting a bug on Connect, incase anyone can shed some light. Thanks.--remove a 9 to reply by email
View 11 Replies
View Related
Oct 22, 2007
We have created a multithreaded application that reads result sets from MS SQL Server (both 2000 and 2005). The MS SQL Server app and our app reside on the same machine. We are using the latest version of ODBC32.DLL (3.526.1830.0) and SQLSRV32.DLL (2000.86.1830). Our application is written in C++ using the Visual C++ 6.0 compiler and libraries. Our app runs as a service, therefore the apparent memory leak is a real problem. Our app needs to run on a server in a closet without human intervention.
We are kicking off many user threads that each can read from the database tables. Each of the reads from the database occurs within a critical section to minimize the threads stepping on each other. The ODBC interface class follows all the steps defined in the ODBC application developers documention (see code below).
We see or app memory steadily increasing over time (we used PerfMon to monitor Private Bytes and Virtual Bytes, per ODBC documentation). If we terminate the threads which are retreiving the result sets, the memory drops back to the level noted prior to starting the threads.
The code below is admittedly inefficient, however, it should not leak memory when accessing the database. Note that it works very well, returns the result sets that we expect exactly.
SQLHENV henv = SQL_NULL_HENV;
SQLHDBC hdbc = SQL_NULL_HDBC;
SQLHSTMT hstmt1 = SQL_NULL_HSTMT;
SQLRETURN retCode;
SQLSMALLINT sColCount = 0;
CODBCInterfaceColumnList lColumnList;
CString strDSN;
CString strUID = _T("AccountName");
CString strPWD = _T("Password");
CString strServer;
CString strDatabase;
CString strDebugMsg;
if(!CreateDSN( pRecordList->m_strDefaultODBCConnect,
strDSN,
strDatabase,
strUID,
strPWD,
strServer))
{
strExceptionMsg.Format( _T("Cannot create DSN from connect string %s"),
pRecordList->m_strDefaultODBCConnect);
bReturn = true;
return bReturn;
}
if(pRecordList->m_strDefaultODBCConnect.IsEmpty())
{
bReturn = true;
return bReturn;
}
// Allocate the environment handle
retCode = SQLAllocHandle(SQL_HANDLE_ENV,NULL, &henv);
if(retCode != SQL_ERROR && retCode != SQL_INVALID_HANDLE)
{
// Set the environment to ODBC Version 3.0
retCode = SQLSetEnvAttr(henv,
SQL_ATTR_ODBC_VERSION,
(SQLPOINTER)SQL_OV_ODBC3,
SQL_IS_INTEGER);
if(retCode != SQL_SUCCESS)
{
GetErrorMsgs(hdbc, SQL_HANDLE_ENV, strDebugMsg);
}
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
// Allocate a ODBC connection handle handle
retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
retCode = SQLConnect( hdbc,
(UCHAR*)(LPCTSTR)strDSN,
SQL_NTS,
(UCHAR*)(LPCTSTR)strUID,
SQL_NTS,
(UCHAR*)(LPCTSTR)strPWD,
SQL_NTS);
if(retCode != SQL_SUCCESS)
{
GetErrorMsgs(hdbc, SQL_HANDLE_DBC, strDebugMsg);
OutputDebugString(strDebugMsg);
}
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
// Allocate a statement handle
retCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt1);
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
// Fixup the select statement
retCode = SQLPrepare( hstmt1,
(UCHAR*)(LPCTSTR)pRecordList->m_strSelectStatement,
pRecordList->m_strSelectStatement.GetLength());
if(retCode == SQL_SUCCESS)
{
retCode = SQLExecute(hstmt1);
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
retCode = SQLNumResultCols(hstmt1,&sColCount);
if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO)
{
if(sColCount > 0)
{
if(lColumnList.DescribeColumns(hstmt1, strExceptionMsg))
{
if(lColumnList.BindColumns(hstmt1, strExceptionMsg))
{
int i = 0;
while((retCode = SQLFetch(hstmt1)) != SQL_NO_DATA)
{
if(retCode != SQL_SUCCESS)
{
GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg);
break;
}
else
{
// Class to hold the result set.
CTableColumnList* pColList = new CTableColumnList();
lColumnList.PopulateColumnListObject(pColList);
pRecordList->AddColumnListRecord(pColList);
}
}
}
}
}
}
}
else
{
GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg);
}
}
else
{
GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg);
}
retCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt1);
}
else
{
GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg);
}
retCode = SQLDisconnect(hdbc);
}
else
{
GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg);
}
}
retCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
}
retCode = SQLFreeHandle(SQL_HANDLE_ENV, henv);
We are at our wits end, not sure what to do next. Any help in sorting this out will be very, VERY much appreciated.
View 3 Replies
View Related
Dec 1, 2006
Found some bad behavior in the 2005 Management Studio Import and Export Wizard.
In the Select Source Tables and Views box, I selected multiple objects, and then clicked Edit Mappings.
The Transfer Settings dialog box appears, and states: "Define the settings that can be applied to all selected table transfers."
I selected the "Delete rows in existing destination tables" option to overwrite the existing data. But Management Studio DID NOT DELETE THE ROWS IN THE EXISTING TABLES. Instead, the records were appended to existing data, wreaking havoc on our month-end accounting system.
This happened multiple times, and occured even though the final screen confirmed that existing records would be deleted in each of the individual tables.
View 2 Replies
View Related
Jan 19, 2004
Hope someone can help me with this because its driving me potty!
I have a .NET script that sends really simple queries to SQL server that works perfectly 50% of the time but for the other 50% it takes ages (2-3 minutes) and then fails, I'm assuming because it times out. I then check the SQL by excecuting it via query analyzer and it again takes ages but will work eventually (I'm assuming because this bypasses the timeout settings, but changing these isn't on).
This happens randomly, the scripts will be working fine and then fail a few times before magically working again!
Any ideas? Perhaps some database features that commonly cause this problem? The problem only occurs with one database, all our others are fine but we can't spot any differences!
Any help or tips would really be appreciated.
Thanks.
View 5 Replies
View Related
Oct 7, 2005
In the master database for a SQL Server instance I noticed the dt... objects (procedures, etc.) in create date of today about 7 minutes before I looked in sysobjects. No changes have been made to that instance for months. Also in other cases I noticed the same thing just different dates for each instance. Any ideas on why the dates would change?
View 1 Replies
View Related
Mar 15, 2007
I used the SQL Server 2005 Upgrade Advisor to upgrade from SQL Server 2000 Enterprise to 2005 Standard. The only complaint I got concerned DTS packages, but I had none anyway. When I open SQL Server Management Studio, I can run queries, but they're against tables in the old 2000 databases. The SQL engine and Server agent are version version 8.0. Not surprising that new TSQL statements like 'BACKUP SERVICE MASTER KEY TO FILE' won't work.
Do I have to uninstall my previous version before upgrading?
Thanks.
View 3 Replies
View Related
Dec 12, 2005
I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies
View Related
Mar 26, 1999
The MS SQL Server SQLMaint Utility returned this error:
[4] Check System Data...
The following errors were found:
Database Corrupt: The last checkpoint in Sysdatabases is incorrect.
Syslogs recorded a different checkpoint
** Execution Time: 0 hrs, 0 mins, 1 secs **
I've read that this is no big deal, that a row in the sysdatabases table
hasn't been updated to reflect the latest checkpoint, and that rebooting
the server would clear this. However, rebooting did not clear it.
Any ideas?
W.
View 1 Replies
View Related
Apr 18, 2008
Here's the dbcc of a corrupt database. I had to eventually run it with data loss and piece together the deleted records from an old backup and drop them in a clean db.
I apologize in advance if there's an faq out there already that explains my answer in detail...
The question I put to you is: 1) How do I we prevent our customers from having this occur again? I can guess the list would include: IO checks, battery backup, SQL 2000 sp4 applied (only sp3 is applied btw), SQL log checks, event log checks. 2) Our custom maint plan includes a dbcc reindex every night and some tables have over 200000 records and a mess of constraints. Is this a potential problem?
Thanks.
dbcc checkdb
-------------
DBCC results for 'mycustdb'.
DBCC results for 'sysobjects'.
There are 3221 rows in 60 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 2694 rows in 223 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16338 rows in 410 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 2176 rows in 609 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 49 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 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 41985 rows in 214 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 547 rows in 4 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 'sysCompany'.
There are 8 rows in 1 pages for object 'sysCompany'.
DBCC results for 'a_admResCensus'.
There are 0 rows in 0 pages for object 'a_admResCensus'.
DBCC results for 'sysTask'.
There are 0 rows in 0 pages for object 'sysTask'.
DBCC results for 'glJournalEntryTemplate'.
There are 7 rows in 1 pages for object 'glJournalEntryTemplate'.
DBCC results for 'admResUdAssessAns'.
There are 0 rows in 0 pages for object 'admResUdAssessAns'.
DBCC results for 'arTAC'.
There are 0 rows in 0 pages for object 'arTAC'.
DBCC results for 'arRecCharge'.
There are 2578 rows in 21 pages for object 'arRecCharge'.
DBCC results for 'arFormLocator'.
There are 1900 rows in 14 pages for object 'arFormLocator'.
DBCC results for 'rptVitalSigns'.
There are 0 rows in 0 pages for object 'rptVitalSigns'.
DBCC results for 'glMajorDepartment'.
There are 0 rows in 0 pages for object 'glMajorDepartment'.
DBCC results for 'a_arTAC'.
There are 0 rows in 0 pages for object 'a_arTAC'.
DBCC results for 'sysUserDefQuesAns'.
There are 5128 rows in 41 pages for object 'sysUserDefQuesAns'.
DBCC results for 'glTransaction'.
There are 67594 rows in 581 pages for object 'glTransaction'.
DBCC results for 'arOccupancyRate'.
There are 144 rows in 1 pages for object 'arOccupancyRate'.
DBCC results for 'sysErrorScreenLink'.
There are 60 rows in 1 pages for object 'sysErrorScreenLink'.
DBCC results for 'arResCaseMix'.
There are 2634 rows in 21 pages for object 'arResCaseMix'.
DBCC results for 'glTransImportTemp'.
There are 0 rows in 1 pages for object 'glTransImportTemp'.
DBCC results for 'arTAR'.
There are 0 rows in 0 pages for object 'arTAR'.
DBCC results for 'admContactTypeLink'.
There are 3460 rows in 15 pages for object 'admContactTypeLink'.
DBCC results for 'arResRoomAndBoard'.
There are 1839 rows in 16 pages for object 'arResRoomAndBoard'.
DBCC results for 'secAccountLink'.
There are 0 rows in 0 pages for object 'secAccountLink'.
DBCC results for 'glTransToArTransLink'.
There are 216168 rows in 478 pages for object 'glTransToArTransLink'.
DBCC results for 'arChargeHistory'.
There are 634 rows in 4 pages for object 'arChargeHistory'.
DBCC results for 'admContPhone'.
There are 3091 rows in 17 pages for object 'admContPhone'.
DBCC results for 'arRevenueCode'.
There are 18 rows in 1 pages for object 'arRevenueCode'.
DBCC results for 'glGroup'.
There are 1 rows in 1 pages for object 'glGroup'.
DBCC results for 'glUnits'.
There are 0 rows in 0 pages for object 'glUnits'.
DBCC results for 'mdsSectionDefinition'.
There are 1735 rows in 71 pages for object 'mdsSectionDefinition'.
DBCC results for 'sysUserDefQuesType'.
There are 6 rows in 1 pages for object 'sysUserDefQuesType'.
DBCC results for 'glUnitType'.
There are 0 rows in 0 pages for object 'glUnitType'.
DBCC results for 'arChargeUpdTemp'.
There are 0 rows in 0 pages for object 'arChargeUpdTemp'.
DBCC results for 'arChargeBatch'.
There are 2 rows in 1 pages for object 'arChargeBatch'.
DBCC results for 'sysWarning'.
There are 0 rows in 0 pages for object 'sysWarning'.
DBCC results for 'sysCustomReportLayouts'.
There are 3 rows in 1 pages for object 'sysCustomReportLayouts'.
DBCC results for 'arCheckPoint'.
There are 5922 rows in 85 pages for object 'arCheckPoint'.
DBCC results for 'arServiceCategory'.
There are 47 rows in 1 pages for object 'arServiceCategory'.
DBCC results for 'tblClassTemp'.
There are 0 rows in 0 pages for object 'tblClassTemp'.
DBCC results for 'secCompUserLink'.
Server: Msg 8941, Level 16, State 102, Line 1
Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 100, offset 0x1 is invalid.
Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 232387897, index ID 0, page (1:35630). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x64 overlaps with the prior row.
There are 33 rows in 1 pages for object 'secCompUserLink'.
DBCC results for 'sysRptMenu'.
There are 4 rows in 1 pages for object 'sysRptMenu'.
DBCC results for 'a_admResDiagnosis'.
There are 0 rows in 0 pages for object 'a_admResDiagnosis'.
DBCC results for 'arPaymentHistory'.
There are 0 rows in 1 pages for object 'arPaymentHistory'.
DBCC results for 'secPermissionLevel'.
There are 4 rows in 1 pages for object 'secPermissionLevel'.
DBCC results for 'arPaymentLink'.
There are 0 rows in 0 pages for object 'arPaymentLink'.
DBCC results for 'a_admResident'.
There are 0 rows in 0 pages for object 'a_admResident'.
DBCC results for 'tblECSLinkTemp'.
There are 0 rows in 0 pages for object 'tblECSLinkTemp'.
DBCC results for 'mdsVersion'.
There are 1 rows in 1 pages for object 'mdsVersion'.
DBCC results for 'arResExportDetail'.
There are 0 rows in 0 pages for object 'arResExportDetail'.
DBCC results for 'tblECSRecordTemp'.
There are 0 rows in 0 pages for object 'tblECSRecordTemp'.
DBCC results for 'sysRptToMenuLink'.
There are 9 rows in 1 pages for object 'sysRptToMenuLink'.
DBCC results for 'arResExportHistory'.
There are 0 rows in 0 pages for object 'arResExportHistory'.
DBCC results for 'arStmtDetailPP'.
There are 98372 rows in 887 pages for object 'arStmtDetailPP'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'arStmtDetailPP' (object ID 232387897).
DBCC results for 'a_admResInsurance'.
There are 0 rows in 0 pages for object 'a_admResInsurance'.
DBCC results for 'sysScrnSetting'.
There are 331 rows in 8 pages for object 'sysScrnSetting'.
DBCC results for 'arStmtChargeLink'.
There are 13594 rows in 148 pages for object 'arStmtChargeLink'.
DBCC results for 'arStmtDetailUB92'.
There are 19070 rows in 221 pages for object 'arStmtDetailUB92'.
DBCC results for 'admGender'.
There are 3 rows in 1 pages for object 'admGender'.
DBCC results for 'arStmtHeaderPP'.
There are 15188 rows in 690 pages for object 'arStmtHeaderPP'.
DBCC results for 'sysMasterFormLocator'.
There are 866 rows in 7 pages for object 'sysMasterFormLocator'.
DBCC results for 'rptMdsResCensusTemp'.
There are 82 rows in 2 pages for object 'rptMdsResCensusTemp'.
DBCC results for 'sysScrnSettingDetail'.
There are 3590 rows in 39 pages for object 'sysScrnSettingDetail'.
DBCC results for 'arTransHistory'.
There are 9767 rows in 57 pages for object 'arTransHistory'.
DBCC results for 'arCalculationType'.
There are 24 rows in 1 pages for object 'arCalculationType'.
DBCC results for 'tblglAcct'.
There are 0 rows in 0 pages for object 'tblglAcct'.
DBCC results for 'arRate'.
There are 1304 rows in 11 pages for object 'arRate'.
DBCC results for 'arStmtTransLink'.
There are 152635 rows in 324 pages for object 'arStmtTransLink'.
DBCC results for 'a_admResNotes'.
There are 0 rows in 0 pages for object 'a_admResNotes'.
DBCC results for 'admMaritalStatus'.
There are 6 rows in 1 pages for object 'admMaritalStatus'.
DBCC results for 'tblglBgtAcct'.
There are 0 rows in 0 pages for object 'tblglBgtAcct'.
DBCC results for 'sysSpellDict'.
There are 15438 rows in 94 pages for object 'sysSpellDict'.
DBCC results for 'arSpecRate'.
There are 40 rows in 1 pages for object 'arSpecRate'.
DBCC results for 'arTFIntsTemp'.
There are 0 rows in 0 pages for object 'arTFIntsTemp'.
DBCC results for 'sysInsuranceType'.
There are 81 rows in 1 pages for object 'sysInsuranceType'.
DBCC results for 'tblglDept'.
There are 0 rows in 0 pages for object 'tblglDept'.
DBCC results for 'tblSpellDict'.
There are 15357 rows in 91 pages for object 'tblSpellDict'.
DBCC results for 'arToGLTemp'.
There are 0 rows in 1 pages for object 'arToGLTemp'.
DBCC results for 'sysUdQuest'.
There are 0 rows in 0 pages for object 'sysUdQuest'.
DBCC results for 'tblglFNPeriod'.
There are 0 rows in 0 pages for object 'tblglFNPeriod'.
DBCC results for 'admResRoom'.
There are 1820 rows in 11 pages for object 'admResRoom'.
DBCC results for 'admResDiagnosis'.
There are 6480 rows in 63 pages for object 'admResDiagnosis'.
DBCC results for 'tblglTrans'.
There are 0 rows in 0 pages for object 'tblglTrans'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'arStatement'.
There are 17784 rows in 102 pages for object 'arStatement'.
DBCC results for 'sysMasterFormVersion'.
There are 51 rows in 1 pages for object 'sysMasterFormVersion'.
DBCC results for 'admComments'.
There are 0 rows in 0 pages for object 'admComments'.
DBCC results for 'tblglUnit'.
There are 0 rows in 0 pages for object 'tblglUnit'.
DBCC results for 'arPercentage'.
There are 2 rows in 1 pages for object 'arPercentage'.
DBCC results for 'arTransLink'.
There are 103583 rows in 372 pages for object 'arTransLink'.
DBCC results for 'a_admResRoom'.
There are 0 rows in 0 pages for object 'a_admResRoom'.
DBCC results for 'mdsAssessment'.
There are 9 rows in 2 pages for object 'mdsAssessment'.
DBCC results for 'arTransLinkTemp'.
There are 0 rows in 1 pages for object 'arTransLinkTemp'.
DBCC results for 'mdsAssessSummary'.
There are 3933 rows in 87 pages for object 'mdsAssessSummary'.
DBCC results for 'sysReportCategories'.
There are 53 rows in 1 pages for object 'sysReportCategories'.
DBCC results for 'a_admResSchdCodePassTime'.
There are 0 rows in 0 pages for object 'a_admResSchdCodePassTime'.
DBCC results for 'admPhyOrderPassTime'.
There are 51 rows in 1 pages for object 'admPhyOrderPassTime'.
DBCC results for 'admTaskData'.
There are 0 rows in 0 pages for object 'admTaskData'.
DBCC results for 'arTransOrigin'.
There are 12 rows in 1 pages for object 'arTransOrigin'.
DBCC results for 'ap1099Form'.
There are 89 rows in 5 pages for object 'ap1099Form'.
DBCC results for 'sysDiagnosis'.
There are 16464 rows in 165 pages for object 'sysDiagnosis'.
DBCC results for 'mdsRugsFormLocators'.
There are 9 rows in 1 pages for object 'mdsRugsFormLocators'.
DBCC results for 'admPhyOrdersHistory'.
There are 20165 rows in 300 pages for object 'admPhyOrdersHistory'.
DBCC results for 'rptTempTable'.
There are 4 rows in 1 pages for object 'rptTempTable'.
DBCC results for 'tblRandomNames'.
There are 0 rows in 0 pages for object 'tblRandomNames'.
DBCC results for 'mdsRugsMedicaid'.
There are 518 rows in 4 pages for object 'mdsRugsMedicaid'.
DBCC results for 'arTransType'.
There are 10 rows in 1 pages for object 'arTransType'.
DBCC results for 'mdsRugsMedicare'.
There are 582 rows in 5 pages for object 'mdsRugsMedicare'.
DBCC results for 'arECSError'.
There are 13 rows in 1 pages for object 'arECSError'.
DBCC results for 'apBatch'.
There are 1771 rows in 15 pages for object 'apBatch'.
DBCC results for 'arOrderTypeServiceLink'.
There are 0 rows in 0 pages for object 'arOrderTypeServiceLink'.
DBCC results for 'a_arBatch'.
There are 0 rows in 0 pages for object 'a_arBatch'.
DBCC results for 'arECSPayment'.
There are 0 rows in 0 pages for object 'arECSPayment'.
DBCC results for 'arTreatment'.
There are 0 rows in 0 pages for object 'arTreatment'.
DBCC results for 'apCheck'.
There are 8822 rows in 83 pages for object 'apCheck'.
DBCC results for 'arECSPmtAdjustment'.
There are 0 rows in 0 pages for object 'arECSPmtAdjustment'.
DBCC results for 'arStmtDetailCMS1500'.
There are 0 rows in 0 pages for object 'arStmtDetailCMS1500'.
DBCC results for 'admProfLink2'.
There are 1890 rows in 8 pages for object 'admProfLink2'.
DBCC results for 'a_arTreatment'.
There are 0 rows in 0 pages for object 'a_arTreatment'.
DBCC results for 'apCheckHistory'.
There are 8800 rows in 44 pages for object 'apCheckHistory'.
DBCC results for 'arStmtHeaderCMS1500'.
There are 0 rows in 0 pages for object 'arStmtHeaderCMS1500'.
DBCC results for 'sysCoPhone'.
There are 13 rows in 1 pages for object 'sysCoPhone'.
DBCC results for 'repUserRptCatLink'.
There are 63 rows in 1 pages for object 'repUserRptCatLink'.
DBCC results for 'dc_ecshst_d'.
There are 0 rows in 0 pages for object 'dc_ecshst_d'.
DBCC results for 'apCheckNumTemp'.
There are 0 rows in 1 pages for object 'apCheckNumTemp'.
DBCC results for 'sysECSAdjReasonCode'.
There are 40 rows in 1 pages for object 'sysECSAdjReasonCode'.
DBCC results for 'hl7ExceptionLog'.
There are 0 rows in 0 pages for object 'hl7ExceptionLog'.
DBCC results for 'apCheckPoint'.
There are 2848 rows in 40 pages for object 'apCheckPoint'.
DBCC results for 'rptErrorWarning'.
There are 66 rows in 5 pages for object 'rptErrorWarning'.
DBCC results for 'hl7MsgQueueIncoming'.
There are 0 rows in 0 pages for object 'hl7MsgQueueIncoming'.
DBCC results for 'admProfPhone'.
There are 155 rows in 1 pages for object 'admProfPhone'.
DBCC results for 'hl7ProcessingErrors'.
There are 0 rows in 0 pages for object 'hl7ProcessingErrors'.
DBCC results for 'arTFBatchDetail'.
There are 2 rows in 1 pages for object 'arTFBatchDetail'.
DBCC results for 'rptFacilityRUGReport'.
There are 0 rows in 0 pages for object 'rptFacilityRUGReport'.
DBCC results for 'hl7RawMsgIncoming'.
There are 0 rows in 0 pages for object 'hl7RawMsgIncoming'.
DBCC results for 'apInvoice'.
There are 12516 rows in 167 pages for object 'apInvoice'.
DBCC results for 'tblDiagSubject'.
There are 1217 rows in 7 pages for object 'tblDiagSubject'.
DBCC results for 'dc_ub92_d'.
There are 0 rows in 0 pages for object 'dc_ub92_d'.
DBCC results for 'mdsAssessSignature'.
There are 4322 rows in 59 pages for object 'mdsAssessSignature'.
DBCC results for 'a_arChargeTransLink'.
There are 0 rows in 0 pages for object 'a_arChargeTransLink'.
DBCC results for 'mdsCMLink'.
There are 105 rows in 2 pages for object 'mdsCMLink'.
DBCC results for 'dosConvertCriteria'.
There are 0 rows in 0 pages for object 'dosConvertCriteria'.
DBCC results for 'admRace'.
There are 6 rows in 1 pages for object 'admRace'.
DBCC results for 'rptMDSAssmtDue'.
There are 0 rows in 1 pages for object 'rptMDSAssmtDue'.
DBCC results for 'a_mdsAssessSignature'.
There are 0 rows in 0 pages for object 'a_mdsAssessSignature'.
DBCC results for 'a_arNote'.
There are 0 rows in 0 pages for object 'a_arNote'.
DBCC results for 'apInvoiceBatch'.
There are 966 rows in 5 pages for object 'apInvoiceBatch'.
DBCC results for 'dosConvertFields'.
There are 392 rows in 3 pages for object 'dosConvertFields'.
DBCC results for 'rptMDSAssmtDueByDate'.
There are 0 rows in 1 pages for object 'rptMDSAssmtDueByDate'.
DBCC results for 'mdsAssessSignTypes'.
There are 9 rows in 1 pages for object 'mdsAssessSignTypes'.
DBCC results for 'a_arPAWorksheetDetail'.
There are 0 rows in 0 pages for object 'a_arPAWorksheetDetail'.
DBCC results for 'apInvoiceBatchDetail'.
There are 47 rows in 1 pages for object 'apInvoiceBatchDetail'.
DBCC results for 'rptMDSCurrentECSItems'.
There are 0 rows in 0 pages for object 'rptMDSCurrentECSItems'.
DBCC results for 'a_arPayment'.
There are 0 rows in 0 pages for object 'a_arPayment'.
DBCC results for 'apInvoiceBatchTransDetail'.
There are 50 rows in 1 pages for object 'apInvoiceBatchTransDetail'.
DBCC results for 'mdsCMMaximizer'.
There are 15 rows in 1 pages for object 'mdsCMMaximizer'.
DBCC results for 'apInvoiceCheckLink'.
There are 12497 rows in 59 pages for object 'apInvoiceCheckLink'.
DBCC results for 'mdsRugsUserRateMC'.
There are 27 rows in 1 pages for object 'mdsRugsUserRateMC'.
DBCC results for 'dosConvertFiles'.
There are 1 rows in 1 pages for object 'dosConvertFiles'.
DBCC results for 'sysAllergyCodes'.
There are 249 rows in 2 pages for object 'sysAllergyCodes'.
DBCC results for 'sysECSFileCount'.
There are 0 rows in 0 pages for object 'sysECSFileCount'.
DBCC results for 'mdsStartDates'.
There are 0 rows in 0 pages for object 'mdsStartDates'.
DBCC results for 'a_arRecCharge'.
There are 0 rows in 0 pages for object 'a_arRecCharge'.
DBCC results for 'apInvoiceHistory'.
There are 12681 rows in 138 pages for object 'apInvoiceHistory'.
DBCC results for 'rptCurrentPrevalence'.
There are 0 rows in 0 pages for object 'rptCurrentPrevalence'.
DBCC results for 'admResAllergy'.
There are 762 rows in 7 pages for object 'admResAllergy'.
DBCC results for 'apMiscAdjMemo'.
There are 0 rows in 0 pages for object 'apMiscAdjMemo'.
DBCC results for 'sysFeatCompanyLink'.
There are 82 rows in 1 pages for object 'sysFeatCompanyLink'.
DBCC results for 'a_arResCaseMix'.
There are 0 rows in 0 pages for object 'a_arResCaseMix'.
DBCC results for 'apNote'.
There are 1 rows in 1 pages for object 'apNote'.
DBCC results for 'rptDiseaseProfile'.
There are 0 rows in 0 pages for object 'rptDiseaseProfile'.
DBCC results for 'a_arResRoomAndBoard'.
There are 0 rows in 0 pages for object 'a_arResRoomAndBoard'.
DBCC results for 'rptDiseaseProfileDetail'.
There are 0 rows in 0 pages for object 'rptDiseaseProfileDetail'.
DBCC results for 'a_arStatement'.
There are 0 rows in 0 pages for object 'a_arStatement'.
DBCC results for 'apPaymentBatch'.
There are 793 rows in 3 pages for object 'apPaymentBatch'.
DBCC results for 'arStmtAdjmtUB92'.
There are 0 rows in 0 pages for object 'arStmtAdjmtUB92'.
DBCC results for 'apPaymentTerms'.
There are 6 rows in 1 pages for object 'apPaymentTerms'.
DBCC results for 'rptFacLongProfile'.
There are 0 rows in 0 pages for object 'rptFacLongProfile'.
DBCC results for 'mdsAnswerNotes'.
There are 6270 rows in 91 pages for object 'mdsAnswerNotes'.
DBCC results for 'a_arStmtDetailCMS1500'.
There are 0 rows in 0 pages for object 'a_arStmtDetailCMS1500'.
DBCC results for 'mdsAnswerReasons'.
There are 28 rows in 1 pages for object 'mdsAnswerReasons'.
DBCC results for 'a_arStmtDetailPP'.
There are 0 rows in 0 pages for object 'a_arStmtDetailPP'.
DBCC results for 'apPmtBatchDetail'.
There are 0 rows in 1 pages for object 'apPmtBatchDetail'.
DBCC results for 'rptHistoricalPrevalence'.
There are 0 rows in 0 pages for object 'rptHistoricalPrevalence'.
DBCC results for 'a_arStmtDetailUB92'.
There are 0 rows in 0 pages for object 'a_arStmtDetailUB92'.
DBCC results for 'apRecInvDetail'.
There are 15 rows in 1 pages for object 'apRecInvDetail'.
DBCC results for 'admContact'.
There are 2346 rows in 18 pages for object 'admContact'.
DBCC results for 'mdsAssessSectionLink'.
There are 222 rows in 1 pages for object 'mdsAssessSectionLink'.
DBCC results for 'admCounty'.
There are 1301 rows in 5 pages for object 'admCounty'.
DBCC results for 'sysGridFilter'.
There are 88 rows in 1 pages for object 'sysGridFilter'.
DBCC results for 'a_arStmtHeaderCMS1500'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderCMS1500'.
DBCC results for 'apRecInvTemp'.
There are 0 rows in 1 pages for object 'apRecInvTemp'.
DBCC results for 'admContactRelation'.
There are 28 rows in 1 pages for object 'admContactRelation'.
DBCC results for 'rptLongResProfileDetail'.
There are 0 rows in 0 pages for object 'rptLongResProfileDetail'.
DBCC results for 'a_arStmtHeaderPP'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderPP'.
DBCC results for 'apRecurringInvoice'.
There are 14 rows in 1 pages for object 'apRecurringInvoice'.
DBCC results for 'admResident'.
There are 1018 rows in 16 pages for object 'admResident'.
DBCC results for 'rptLongResProfileHeader'.
There are 0 rows in 0 pages for object 'rptLongResProfileHeader'.
DBCC results for 'sysListMenu'.
There are 24 rows in 1 pages for object 'sysListMenu'.
DBCC results for 'a_arStmtHeaderUB92'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUB92'.
DBCC results for 'sysFeature'.
There are 34 rows in 1 pages for object 'sysFeature'.
DBCC results for 'sysCountyIndex'.
There are 10331 rows in 76 pages for object 'sysCountyIndex'.
DBCC results for 'sysListSettings'.
There are 144 rows in 2 pages for object 'sysListSettings'.
DBCC results for 'a_arTransaction'.
There are 0 rows in 0 pages for object 'a_arTransaction'.
DBCC results for 'apStartPaidBalance'.
There are 0 rows in 0 pages for object 'apStartPaidBalance'.
DBCC results for 'admResNotes'.
There are 248 rows in 3 pages for object 'admResNotes'.
DBCC results for 'secDefaultGroups'.
There are 476 rows in 4 pages for object 'secDefaultGroups'.
DBCC results for 'apStatement'.
There are 0 rows in 0 pages for object 'apStatement'.
DBCC results for 'arService'.
There are 312 rows in 4 pages for object 'arService'.
DBCC results for 'secUserAlertLink'.
There are 3 rows in 1 pages for object 'secUserAlertLink'.
DBCC results for 'sysLaborPercentage'.
There are 10 rows in 1 pages for object 'sysLaborPercentage'.
DBCC results for 'audAccess'.
There are 145672 rows in 1092 pages for object 'audAccess'.
DBCC results for 'sysGovRelationship'.
There are 20 rows in 1 pages for object 'sysGovRelationship'.
DBCC results for 'sysAlert'.
There are 3 rows in 1 pages for object 'sysAlert'.
DBCC results for 'sysMasterForm'.
There are 6 rows in 1 pages for object 'sysMasterForm'.
DBCC results for 'audAction'.
There are 0 rows in 0 pages for object 'audAction'.
DBCC results for 'apStmtTransLink'.
There are 0 rows in 0 pages for object 'apStmtTransLink'.
DBCC results for 'arStmtHeaderUB92'.
There are 2234 rows in 315 pages for object 'arStmtHeaderUB92'.
DBCC results for 'mdsDiagnosisCPLink'.
There are 0 rows in 0 pages for object 'mdsDiagnosisCPLink'.
DBCC results for 'audEvent'.
There are 301723 rows in 1240 pages for object 'audEvent'.
DBCC results for 'apTransaction'.
There are 21579 rows in 181 pages for object 'apTransaction'.
DBCC results for 'sysImportLog'.
There are 998 rows in 8 pages for object 'sysImportLog'.
DBCC results for 'mdsECSBatchInfo'.
There are 585 rows in 7 pages for object 'mdsECSBatchInfo'.
DBCC results for 'audEventType'.
There are 17 rows in 1 pages for object 'audEventType'.
DBCC results for 'sysMasterCP'.
There are 23 rows in 1 pages for object 'sysMasterCP'.
DBCC results for 'sysCaseMixVersion'.
There are 9 rows in 1 pages for object 'sysCaseMixVersion'.
DBCC results for 'mdsLock'.
There are 0 rows in 1 pages for object 'mdsLock'.
DBCC results for 'audLogin'.
There are 5399 rows in 42 pages for object 'audLogin'.
DBCC results for 'apTransDetail'.
There are 45417 rows in 254 pages for object 'apTransDetail'.
DBCC results for 'sysCaseMixVersionLink'.
There are 343 rows in 1 pages for object 'sysCaseMixVersionLink'.
DBCC results for 'mdsMDSCPLink'.
There are 12 rows in 1 pages for object 'mdsMDSCPLink'.
DBCC results for 'audTableActionLink'.
There are 0 rows in 0 pages for object 'audTableActionLink'.
DBCC results for 'apTransDetailTemp'.
There are 0 rows in 1 pages for object 'apTransDetailTemp'.
DBCC results for 'sysMedAllergyLink'.
There are 0 rows in 0 pages for object 'sysMedAllergyLink'.
DBCC results for 'sysUdAssess'.
There are 0 rows in 0 pages for object 'sysUdAssess'.
DBCC results for 'mdsMedCPLink'.
There are 0 rows in 0 pages for object 'mdsMedCPLink'.
DBCC results for 'sysControlSubstance'.
There are 7 rows in 1 pages for object 'sysControlSubstance'.
DBCC results for 'a_ecsRecords'.
There are 0 rows in 0 pages for object 'a_ecsRecords'.
DBCC results for 'apTransDetailType'.
There are 9 rows in 1 pages for object 'apTransDetailType'.
DBCC results for 'sysMedia'.
There are 570 rows in 3 pages for object 'sysMedia'.
DBCC results for 'mdsRAPs'.
There are 18 rows in 1 pages for object 'mdsRAPs'.
DBCC results for 'sysProcess'.
There are 31953 rows in 147 pages for object 'sysProcess'.
DBCC results for 'apTransHistory'.
There are 20944 rows in 49 pages for object 'apTransHistory'.
DBCC results for 'sysResSumByProbRptList'.
There are 39 rows in 2 pages for object 'sysResSumByProbRptList'.
DBCC results for 'arUserDefRate'.
There are 32 rows in 1 pages for object 'arUserDefRate'.
DBCC results for 'mdsRAPTriggerCPLink'.
There are 0 rows in 0 pages for object 'mdsRAPTriggerCPLink'.
DBCC results for 'sysDiagSubject'.
There are 1240 rows in 7 pages for object 'sysDiagSubject'.
DBCC results for 'admDischargeCode'.
There are 17 rows in 1 pages for object 'admDischargeCode'.
DBCC results for 'apTransOrigin'.
There are 4 rows in 1 pages for object 'apTransOrigin'.
DBCC results for 'a_admCarePlan'.
There are 0 rows in 0 pages for object 'a_admCarePlan'.
DBCC results for 'sysUdQuestAns'.
There are 0 rows in 0 pages for object 'sysUdQuestAns'.
DBCC results for 'sysECSEntityQualifier'.
There are 25 rows in 1 pages for object 'sysECSEntityQualifier'.
DBCC results for 'admMilitaryBranch'.
There are 6 rows in 1 pages for object 'admMilitaryBranch'.
DBCC results for 'a_mdsAnswerNotes'.
There are 0 rows in 0 pages for object 'a_mdsAnswerNotes'.
DBCC results for 'apTransType'.
There are 4 rows in 1 pages for object 'apTransType'.
DBCC results for 'sysUdQuestType'.
There are 10 rows in 1 pages for object 'sysUdQuestType'.
DBCC results for 'mdsRAPVersionLink'.
There are 18 rows in 1 pages for object 'mdsRAPVersionLink'.
DBCC results for 'sysECSFileFormat'.
There are 3 rows in 1 pages for object 'sysECSFileFormat'.
DBCC results for 'a_mdsAnswerReasons'.
There are 0 rows in 0 pages for object 'a_mdsAnswerReasons'.
DBCC results for 'apVendor'.
There are 1776 rows in 13 pages for object 'apVendor'.
DBCC results for 'tblResSumByProbRptList'.
There are 37 rows in 1 pages for object 'tblResSumByProbRptList'.
DBCC results for 'sysECSFileFormatVer'.
There are 21 rows in 1 pages for object 'sysECSFileFormatVer'.
DBCC results for 'admReligion'.
There are 49 rows in 1 pages for object 'admReligion'.
DBCC results for 'sysReportCatFields'.
There are 1311 rows in 17 pages for object 'sysReportCatFields'.
DBCC results for 'a_mdsAssessSummary'.
There are 0 rows in 0 pages for object 'a_mdsAssessSummary'.
DBCC results for 'a_arCharge'.
There are 0 rows in 0 pages for object 'a_arCharge'.
DBCC results for 'sysMedWarningLink'.
There are 0 rows in 0 pages for object 'sysMedWarningLink'.
DBCC results for 'sysECSFormVerToFileFormatVerLink'.
There are 50 rows in 1 pages for object 'sysECSFormVerToFileFormatVerLink'.
DBCC results for 'sysECSSrcPmtCodeMap'.
There are 11 rows in 1 pages for object 'sysECSSrcPmtCodeMap'.
DBCC results for 'admState'.
There are 53 rows in 1 pages for object 'admState'.
DBCC results for 'arAccount'.
There are 1555 rows in 16 pages for object 'arAccount'.
DBCC results for 'sysFDACode'.
There are 7 rows in 1 pages for object 'sysFDACode'.
DBCC results for 'sysReportCatFK'.
There are 70 rows in 1 pages for object 'sysReportCatFK'.
DBCC results for 'apVendorContact'.
There are 13 rows in 1 pages for object 'apVendorContact'.
DBCC results for 'sysOrderType'.
There are 22 rows in 1 pages for object 'sysOrderType'.
DBCC results for 'a_secAccessControl'.
There are 0 rows in 0 pages for object 'a_secAccessControl'.
DBCC results for 'mdsReactionActions'.
There are 838 rows in 4 pages for object 'mdsReactionActions'.
DBCC results for 'arAccountType'.
There are 22 rows in 1 pages for object 'arAccountType'.
DBCC results for 'sysFreqCodes'.
There are 24 rows in 1 pages for object 'sysFreqCodes'.
DBCC results for 'a_secAccountLink'.
There are 0 rows in 0 pages for object 'a_secAccountLink'.
DBCC results for 'apVendorPhone'.
There are 567 rows in 3 pages for object 'apVendorPhone'.
DBCC results for 'rptCarePlan'.
There are 0 rows in 0 pages for object 'rptCarePlan'.
DBCC results for 'secAccountPwdHistory'.
There are 0 rows in 0 pages for object 'secAccountPwdHistory'.
DBCC results for 'apVoidReason'.
There are 23 rows in 1 pages for object 'apVoidReason'.
DBCC results for 'a_secAccounts'.
There are 0 rows in 0 pages for object 'a_secAccounts'.
DBCC results for 'a_arStmtHeaderUB04'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUB04'.
DBCC results for 'sysResSumByProbRptECSKeys'.
There are 172 rows in 1 pages for object 'sysResSumByProbRptECSKeys'.
DBCC results for 'arStmtDetailUCF'.
There are 0 rows in 0 pages for object 'arStmtDetailUCF'.
DBCC results for 'arStmtHeaderUB04'.
There are 362 rows in 67 pages for object 'arStmtHeaderUB04'.
DBCC results for 'mdsReactionCauses'.
There are 932 rows in 4 pages for object 'mdsReactionCauses'.
DBCC results for 'rptKeyLookup'.
There are 85 rows in 2 pages for object 'rptKeyLookup'.
DBCC results for 'sysGridColumn'.
There are 768 rows in 10 pages for object 'sysGridColumn'.
DBCC results for 'admResSchdCodePassTime'.
There are 0 rows in 0 pages for object 'admResSchdCodePassTime'.
DBCC results for 'sysSQL'.
There are 17 rows in 7 pages for object 'sysSQL'.
DBCC results for 'a_arStmtDetailUCF'.
There are 0 rows in 0 pages for object 'a_arStmtDetailUCF'.
DBCC results for 'rptFlowsheetResidents'.
There are 0 rows in 0 pages for object 'rptFlowsheetResidents'.
DBCC results for 'sysPGA'.
There are 1166 rows in 19 pages for object 'sysPGA'.
DBCC results for 'arStmtHeaderUCF'.
There are 0 rows in 0 pages for object 'arStmtHeaderUCF'.
DBCC results for 'rptMDSResRoster'.
There are 84 rows in 3 pages for object 'rptMDSResRoster'.
DBCC results for 'a_arStmtHeaderUCF'.
There are 0 rows in 0 pages for object 'a_arStmtHeaderUCF'.
DBCC results for 'rptNAAFormResidents'.
There are 0 rows in 0 pages for object 'rptNAAFormResidents'.
DBCC results for 'sysPGAMCPLink'.
There are 191 rows in 1 pages for object 'sysPGAMCPLink'.
DBCC results for 'sysUserScreenSettings'.
There are 25 rows in 1 pages for object 'sysUserScreenSettings'.
DBCC results for 'glAcctAttribute'.
There are 19 rows in 1 pages for object 'glAcctAttribute'.
DBCC results for 'rptResidentinfo'.
There are 2 rows in 1 pages for object 'rptResidentinfo'.
DBCC results for 'glAcctToDistCodeLink'.
There are 0 rows in 0 pages for object 'glAcctToDistCodeLink'.
DBCC results for 'admNATasks'.
There are 0 rows in 0 pages for object 'admNATasks'.
DBCC results for 'glAttribute'.
There are 4 rows in 1 pages for object 'glAttribute'.
DBCC results for 'admCarePlan'.
There are 671 rows in 14 pages for object 'admCarePlan'.
DBCC results for 'secAccessControl'.
There are 9474 rows in 44 pages for object 'secAccessControl'.
DBCC results for 'admPhyOrders'.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27978) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27979) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27980) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27981) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27982) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27983) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 2534, Level 16, State 1, Line 1
Table error: Page (1:27984) with object ID 1395757021, index ID 0 in its header is allocated by another object.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 94 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 0, page (1:27985), row 1. Test (GetRecType (pRec) >= 0 && GetRecType (pRec) <= LAST_REC_TYPE) failed. Values are 14 and 12.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:27977), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27978) but are not in the same object.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1395757021, index ID 1, and page (1:28007), slot 0, in object ID 1539757534, index ID 1, next refer to page (1:27984) but are not in the same object.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1395757021, index ID 1. B-tree chain linkage mismatch. (1:28007)->next = (1:27984), but (1:27984)->Prev = (1:27983).
Server: Msg 8937, Level 16, State 1, Line 1
Table error: Object ID 1539080819, index ID 20. B-tree page (1:14640) has two parent nodes (0:1), slot 0 and (0:0), slot 0.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27978) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27979) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27980) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27981) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27982) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27983) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:27984) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:27985) could not be processed. See other errors for details.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35629) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:35630) could not be processed. See other errors for details.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35638) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35639) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35640) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35641) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35642) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35643) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35644) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1539757534, index ID 0: Page (1:35785) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 0, page (1:35785), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 133 and 57.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35786) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35787) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:35788) allocated to object ID 1539757534, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:27968) is missing a reference from previous page (1:27983). Possible chain linkage problem.
Server: Msg 8982, Level 16, State 1, Line 1
Table error: Cross object linkage. Page (1:27977)->next in object ID 1539757534, index ID 1 refers to page (1:27978) in object ID 1395757021, index ID 1 but is not in the same index.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 88, in object ID 1539757534, index ID 1, refers to page (1:27984), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (1:28984), slot 89, in object ID 1539757534, index ID 1, and page (1:27984), slot 0, in object ID 1395757021, index ID 1, next refer to page (1:27985) but are not in the same object.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 98, in object ID 1539757534, index ID 1, refers to page (1:27978), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 99, in object ID 1539757534, index ID 1, refers to page (1:27979), slot 0, in object ID 1395757021, index ID 1.
There are 4539 rows in 75 pages for object 'admPhyOrders'.
DBCC results for 'a_secCompUserLink'.
There are 0 rows in 0 pages for object 'a_secCompUserLink'.
DBCC results for 'glDueToDueFrom'.
There are 0 rows in 0 pages for object 'glDueToDueFrom'.
DBCC results for 'sysInfo'.
There are 1 rows in 1 pages for object 'sysInfo'.
DBCC results for 'arPayment'.
There are 24361 rows in 360 pages for object 'arPayment'.
CHECKDB found 0 allocation errors and 12 consistency errors in table 'arPayment' (object ID 1395757021).
DBCC results for 'glTransToAPTransLink'.
There are 44021 rows in 101 pages for object 'glTransToAPTransLink'.
DBCC results for 'secGenSettings'.
There are 1 rows in 1 pages for object 'secGenSettings'.
DBCC results for 'mdsQuestions'.
There are 1716 rows in 19 pages for object 'mdsQuestions'.
DBCC results for 'arBillingCategory'.
There are 13 rows in 1 pages for object 'arBillingCategory'.
DBCC results for 'sysTaskCodes'.
There are 0 rows in 0 pages for object 'sysTaskCodes'.
DBCC results for 'arBatch'.
There are 4147 rows in 45 pages for object 'arBatch'.
DBCC results for 'arBillingForm'.
There are 16 rows in 1 pages for object 'arBillingForm'.
DBCC results for 'arPaymentBatchDetail'.
There are 2 rows in 1 pages for object 'arPaymentBatchDetail'.
DBCC results for 'sysWizardPage'.
There are 67 rows in 1 pages for object 'sysWizardPage'.
DBCC results for 'tblapVendor'.
There are 0 rows in 0 pages for object 'tblapVendor'.
DBCC results for 'a_admPhyOrderAdmin'.
There are 0 rows in 0 pages for object 'a_admPhyOrderAdmin'.
DBCC results for 'arBillingParty'.
There are 64 rows in 1 pages for object 'arBillingParty'.
DBCC results for 'sysWizardSettings'.
There are 22 rows in 1 pages for object 'sysWizardSettings'.
DBCC results for 'a_secGenSettings'.
There are 0 rows in 0 pages for object 'a_secGenSettings'.
DBCC results for 'sysInsuranceProvider'.
There are 78 rows in 1 pages for object 'sysInsuranceProvider'.
DBCC results for 'a_admResPGA'.
There are 0 rows in 0 pages for object 'a_admResPGA'.
DBCC results for 'arCharge'.
There are 80123 rows in 1521 pages for object 'arCharge'.
DBCC results for 'admResCensus'.
There are 303 rows in 2 pages for object 'admResCensus'.
DBCC results for 'rptAssessmentScreening'.
There are 0 rows in 0 pages for object 'rptAssessmentScreening'.
DBCC results for 'arBPartyInsTypeLink'.
There are 26 rows in 1 pages for object 'arBPartyInsTypeLink'.
DBCC results for 'sysMedicationFile'.
There are 168 rows in 3 pages for object 'sysMedicationFile'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysMedicationFile' (object ID 1539080819).
DBCC results for 'arTransaction'.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 100, in object ID 1539757534, index ID 1, refers to page (1:27980), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 101, in object ID 1539757534, index ID 1, refers to page (1:27981), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 102, in object ID 1539757534, index ID 1, refers to page (1:27982), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8925, Level 16, State 1, Line 1
Table error: Cross object linkage: Page (1:28984), slot 103, in object ID 1539757534, index ID 1, refers to page (1:27983), slot 0, in object ID 1395757021, index ID 1.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35624) is missing a reference from previous page (1:35639). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35629) was not seen in the scan although its parent (1:36209) and previous (1:35628) refer to it. Check any previous errors.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35638) was not seen in the scan although its parent (1:36209) and previous (1:35637) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 262 refers to child page (1:35639) and previous child (1:35638), but they were not encountered.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35640) was not seen in the scan although its parent (1:36209) and previous (1:35655) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 248 refers to child page (1:35641) and previous child (1:35640), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 249 refers to child page (1:35642) and previous child (1:35641), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 250 refers to child page (1:35643) and previous child (1:35642), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 251 refers to child page (1:35644) and previous child (1:35643), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35645) is missing a reference from previous page (1:35644). Possible chain linkage problem.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 202 refers to child page (1:35787) and previous child (1:35786), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Index node page (1:36209), slot 203 refers to child page (1:35788) and previous child (1:35787), but they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 1. Page (1:35789) is missing a reference from previous page (1:35788). Possible chain linkage problem.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24303) (level 0) is not less than the low key value in the parent (1:24802), slot 160 of the next page (1:24288).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24304) (level 0) is not less than the low key value in the parent (1:24802), slot 145 of the next page (1:24305).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24305) (level 0) is not less than the low key value in the parent (1:24802), slot 146 of the next page (1:24306).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24306) (level 0) is not less than the low key value in the parent (1:24802), slot 147 of the next page (1:24307).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24307) (level 0) is not less than the low key value in the parent (1:24802), slot 148 of the next page (1:24308).
Server: Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24308) (level 0) is not less than the low key value in the parent (1:24802), slot 149 of the next page (1:24309).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 20. The high key value on page (1:24309) (level 0) is not less than the low key value in the parent (1:24802), slot 150 of the next page (1:24310).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 332 and 333.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 20. Keys out of order on page (1:24310), slots 333 and 334.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The next pointer of (1:22815) refers to page (1:22760). Neither (1:22760) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. Page (1:22800) is missing a reference from previous page (1:22815). Possible chain linkage problem.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22810) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22811).
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22811) (level 0) is not >= the key value in the parent (1:23522) slot 321.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22812) (level 0) is not >= the key value in the parent (1:23522) slot 322.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22813) (level 0) is not >= the key value in the parent (1:23522) slot 323.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22814) (level 0) is not >= the key value in the parent (1:23522) slot 324.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22815) (level 0) is not >= the key value in the parent (1:23522) slot 325.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22816) (level 0) is not >= the key value in the parent (1:23522) slot 310.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22817) (level 0) is not >= the key value in the parent (1:23522) slot 311.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 333 and 334.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 21. Keys out of order on page (1:22825), slots 546 and 547.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22826) (level 0) is not >= the key value in the parent (1:23522) slot 304.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22827) (level 0) is not >= the key value in the parent (1:23522) slot 305.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22828) (level 0) is not >= the key value in the parent (1:23522) slot 306.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22829) (level 0) is not >= the key value in the parent (1:23522) slot 307.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22830) (level 0) is not >= the key value in the parent (1:23522) slot 308.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22831) (level 0) is not >= the key value in the parent (1:23522) slot 309.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The low key value on page (1:22832) (level 0) is not >= the key value in the parent (1:23522) slot 294.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 21. The high key value on page (1:22847) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:22832).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20555) (level 0) is not less than the low key value in the parent (1:20578), slot 27 of the next page (1:20556).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20556) (level 0) is not less than the low key value in the parent (1:20578), slot 28 of the next page (1:20557).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20557) (level 0) is not less than the low key value in the parent (1:20578), slot 29 of the next page (1:20558).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20558) (level 0) is not less than the low key value in the parent (1:20578), slot 30 of the next page (1:20559).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20559) (level 0) is not less than the low key value in the parent (1:20578), slot 31 of the next page (1:20544).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 332 and 333.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 418 and 419.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 24. Keys out of order on page (1:20560), slots 546 and 547.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20568) (level 0) is not less than the low key value in the parent (1:20578), slot 8 of the next page (1:20569).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20569) (level 0) is not less than the low key value in the parent (1:20578), slot 9 of the next page (1:20570).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 24. The high key value on page (1:20570) (level 0) is not less than the low key value in the parent (1:20578), slot 10 of the next page (1:20571).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19467) (level 0) is not less than the low key value in the parent (1:19922), slot 297 of the next page (1:19468).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19468) (level 0) is not less than the low key value in the parent (1:19922), slot 298 of the next page (1:19469).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19469) (level 0) is not less than the low key value in the parent (1:19922), slot 299 of the next page (1:19470).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19470) (level 0) is not less than the low key value in the parent (1:19922), slot 300 of the next page (1:19471).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19471) (level 0) is not less than the low key value in the parent (1:19922), slot 301 of the next page (1:19456).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19472) (level 0) is not less than the low key value in the parent (1:19922), slot 286 of the next page (1:19473).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19480) (level 0) is not less than the low key value in the parent (1:19922), slot 278 of the next page (1:19481).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 417 and 418.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19480), slots 545 and 546.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19481) (level 0) is not less than the low key value in the parent (1:19922), slot 279 of the next page (1:19482).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19482) (level 0) is not less than the low key value in the parent (1:19922), slot 280 of the next page (1:19483).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19835) (level 0) is not less than the low key value in the parent (1:19922), slot 95 of the next page (1:19836).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19836) (level 0) is not less than the low key value in the parent (1:19922), slot 96 of the next page (1:19837).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19837) (level 0) is not less than the low key value in the parent (1:19922), slot 97 of the next page (1:19838).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19838) (level 0) is not less than the low key value in the parent (1:19922), slot 98 of the next page (1:19839).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19839) (level 0) is not less than the low key value in the parent (1:19922), slot 99 of the next page (1:19824).
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1539757534, Index ID 25. Keys out of order on page (1:19840), slots 332 and 333.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 1539757534, index ID 25. The high key value on page (1:19850) (level 0) is not less than the low key value in the parent (1:19922), slot 78 of the next page (1:19851).
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, index ID 26, and page (1:18935), slot 0, in object ID 1539757534, index ID 27, next refer to page (1:18920) but are not in the same object.
Server: Msg 8926, Level 16, State 1, Line 1
Table error: Cross object linkage: Parent page (0:1), slot 0, in object ID 1539757534, ind
View 7 Replies
View Related
Nov 2, 2005
A rouge 6.5 DB was brought to my attention a few weeks ago. We can't upgrade until we solve some corruption issues. We're receiving the listed message after running a DBCC NEWALLOC. We're not sure but we believe the corruption is with a primary key. We can't drop the primary key without of course, first dropping all the foreign keys. ALLOW_DATA_LOSS wasn't introduced until 7.0. Rebuilding the indexes doesn't fix the problem. Does anyone have any suggestion on how to fix this corruption? Any help is appreciated. Restoring isn't an option as this corruption exists in the oldest backup we have...
thanks in advance
************
TABLE: ABS_PAT_INSURANCES OBJID = 204527762
INDID=1 FIRST=4041968 ROOT=4039657 DPAGES=14304 SORT=0
Msg 2525, Level 16, State 1
Table Corrupt: Object id wrong; tables: alloc page 4036864 extent id=4036880 l page#=4036880 objid in ext=204527762 (name = ABS_PAT_INSURANCES) objid in page=348528275 (name = ABS_PAT_MAIN)objid in sysindexes=204527762 (name = ABS_PAT_INSURANCES)
Data level: 1. 0 Data Pages in 1789 extents.
INDID=2 FIRST=3926064 ROOT=3917574 DPAGES=4305 SORT=1
Msg 2525, Level 16, State 1
Table Corrupt: Object id wrong; tables: alloc page 3926016 extent id=3926064 l page#=3926064 objid in ext=204527762 (name = ABS_PAT_INSURANCES) objid in page=348528275 (name = ABS_PAT_MAIN)objid in sysindexes=204527762 (name = ABS_PAT_INSURANCES)
TOTAL # of extents = 1789
View 5 Replies
View Related
Dec 17, 2007
I tried to paste the whole file but didn't work. So here is a small part of it. Anyone know how i could solve it. Thanks
v 16, State 1, Line 1 : DBCC results for 'SW_DS_FINAL_SUM'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 15 rows in 1 pages for object "SW_DS_FINAL_SUM". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'BOM_Active_Sku_DV_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 12610 rows in 789 pages for object "BOM_Active_Sku_DV_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_city'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 3 pages for object "ml_city". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Monthly_SalesReps_2006_2007_SalesReps_List'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 546 rows in 15 pages for object "Monthly_SalesReps_2006_2007_SalesReps_List". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_2008_IPG_Comp_Program_Report'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 9 rows in 1 pages for object "ADHOC_2008_IPG_Comp_Program_Report". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'swidziun.TEMPCDVAR'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 21 rows in 1 pages for object "swidziun.TEMPCDVAR". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Adhoc_Dom_April_July'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 30522 rows in 3393 pages for object "Adhoc_Dom_April_July". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_QTD_FLEX'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 13 rows in 1 pages for object "SW_DS_QTD_FLEX". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'cr_parent_top10'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "cr_parent_top10". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'laugusti.Sheet1$'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 518 rows in 2 pages for object "laugusti.Sheet1$". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'LUC_Top20_Step3'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 29412 rows in 898 pages for object "LUC_Top20_Step3". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ADHOC_STRETCH_2007_DOM_DATA_REPORT'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 844 rows in 21 pages for object "ADHOC_STRETCH_2007_DOM_DATA_REPORT". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'WEEKLY_SUBCLASS_BF_LQ'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 5610 rows in 99 pages for object "WEEKLY_SUBCLASS_BF_LQ". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_city_final'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 640 rows in 8 pages for object "ML_city_final". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ML_ORDERS_2007'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 299291 rows in 5173 pages for object "ML_ORDERS_2007". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'ml_xpdex_user_name'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 97 pages for object "ml_xpdex_user_name". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'SW_DS_BOOKED_ORDERS'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 0 rows in 0 pages for object "SW_DS_BOOKED_ORDERS". [SQLSTATE 01000]
Msg 2536, Sev 16, State 1, Line 1 : DBCC res
http://www.sqlserverstudy.com
View 4 Replies
View Related
