Corruption At Column-Level~~

Dec 22, 2007

Is it possible to have a corruption in one of the columns in a table at a specific row? If yes, what could be the possible causes for such corruption?
Why I am asking? Because it happened that I wasn't able to read the value of a specific column but I was able to update it with other value! it sounds weird if you are able to write but not to read!!
**I wasn't able to read but after I updated it with another value...it was readable...
Please advise...??

View 1 Replies

Column Level Or Database Level Encryption/decryption....

Jan 16, 2008

I want to perform column level and database level encryption/decryption....
Does any body have that code written in C# or VB.NET for AES-128, AES-192, AES-256 algorithms...
I have got code for single string... but i want to encrypt/decrypt columns and sometimes the whole database...
Can anybody help me out...
If you have Store procedure in SQL for the same then also it ll do...
Thanks in advance

View 1 Replies View Related

SQL ALTER COLUMN Causes A Possible Schema Corruption.

Jun 15, 2006

Hi all,

I��m trying to run this SQL statement in 2005 express;

��ALTER TABLE test ALTER COLUMN testfield varchar(5600) NULL��

Testfield exists in database as a varchar(8000).

Express bombs with;

Msg 211, Level 23, State 7, Line 1
Possible schema corruption. Run DBCC CHECKCATALOG.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

Thanks in advance.

Tristan

View 10 Replies View Related

Column Level Constraints

Jul 17, 2001

Hello all.

First of all, I've been a reader of swynk.com for quite sometime now, and I'd like to say 'thank you' to everyone who contributes.

Today, I'm the town moron.. haha I'm having issues with column level constraints. I have a varchar(50) where I want to keep *,=,#,/, .. etc, OUT OF the value input. I don't want to strip them. I simply want for sql to throw an error if the insert contains those (and other characters). The only characters that I want in the column are A-Z and 0-9. However, it's not a set number of characters per insert. It always varies... There has to be an easier way to do this than creating a constraint for every possibilty... Any help would be greatly appreciated.

tia,

Jeremy

View 4 Replies View Related

Concurrency Down To The Column Level - Sql

May 15, 2007

Using VS05 pro SP1...

(I AM REPOSTING THIS IN SQL FROM VB LANGUAGE BECAUSE I RECEIVED NO RESPONSES...ANY HELP WOULD BE APPRECIATED)

This is for a telephony application using Last In Wins concurrency...

Basically, we want to update only the columns that have changed in a row, not the entire row with the few changed columns. We are using TableAdapters exclusively.

We need concurrency down to the column level...that is to say, if a concurrency exception is thrown, we don't just want the new row to be UPDATED and overwrite the old row in the datasource...we only want the new columns to be UPDATED to the datasource...consider the following sequence...

- Fill table A and table B identically

- change column1 value in table A

- Update table A

- change column2 value in table B

- Update table B - this will generate a concurrency error.

Most of the help centers around using the merge command, to update table B, but in the situation above, we would lose the change to column1 (which we don't want to loose). Merge preserves the changes in table B (column2), but it would have the old value for column1, thus we would loose the value in column 1 when we updated the new merged table.

So, we need a way to build a datatable made up of the values in the datasouce plus the changes in the table B, which we will then update.

I have played endlessly with for/next type of constructs to build the new table of new column values using row version data, but I cannot get it to happen.

Upon exception for UPDATING table B, how do we build a temporary table from the datasource (so we get the change to column 1) and the new changes in table B, so we can update the temporary table and not loose any data.

Thanks!

Bob

View 1 Replies View Related

Column Level Security

Apr 29, 2008

Hey,
I have 3 columns in a table Ex:
Select Column1,Column2,Column from TableName

No. 1. Person A should have permission to read values only (Column1, Column3 of the table) -
2. Person B, should have permission to read only (Column 2).

Here my question is , I have to write one single stored procedure to statisfy both conditions. Which means, if person A execute this stored procedure , he shoud get only column 1 & 3 values . similarly other person b should get column 2 value. Ex:
Column 1 - Empid
Column 2 - SSN (Only for Top user display)
Column 3 - Join Date
Person A & B as a SQL or Windows login

Thanks

View 1 Replies View Related

Column Level Permissions For Server 7

Jun 24, 2000

Is there a graphical tool to manage column-level permissions just as it was possible in Enterprise Manager for Server 6.X ?

View 1 Replies View Related

Global Column Level Security - Best Way?

Apr 30, 2008

Hi,

I am trying to find the best way to implement a complex column based security.
Basically i need to secure data among lot of tables with millions of rows, so that some users may see some columns and others see diferent ones...
Whats the best way to implement this kind of procedure securely and flexible?

Best Regards,

View 4 Replies View Related

T-SQL (SS2K8) :: Combining Result In Column Level

May 14, 2014

Below is my sample table and data

With Item as(
Select 1 as ItemId,'ItemName1' as ItemName,100 as position union all
Select 2 as ItemId,'ItemName2' as ItemName,200 as position union all
Select 3 as ItemId,'ItemName3' as ItemName,300 as position union all
Select 4 as ItemId,'ItemName4' as ItemName,400 as position union all
Select 5 as ItemId,'ItemName5' as ItemName,500 as position union all
Select 6 as ItemId,'ItemName6' as ItemName,600 as position union all
Select 7 as ItemId,'ItemName7' as ItemName,700 as position),

Mapping as (
Select 1 as Parent, 2 as child union all
Select 1 as Parent, 3 as child union all
Select 1 as Parent, 4 as child union all
Select 5 as Parent, 6 as child union all
Select 5 as Parent, 7 as child )Expected Result:

ParentItemIdParentItemNameParentpositionChildItemIdChildItemNameChildposition
1ItemName11002ItemName2200
1ItemName11003ItemName3300
1ItemName11004ItemName4400
5ItemName55006ItemName6600
5ItemName55007ItemName7700

I was thinking to achieve using union all but if i use union all it will combine the result in rows level. but i need in column level.

View 5 Replies View Related

Unable To Resolve Column Level Collations

May 14, 2008

Hi,

When I try to execute a package I get this following error. I have a bunch of similar packages which runs fine on the same source(sybase) and destination(sqlserver 2005), just different tables. Only few of them fails and all of them have the same error of "Unable to resolve column level collations. Bulk-copy cannot continue". I checked for the dtatatype and length between source and destination, both are same. The user have all the required rights on the objects in both source and destination.

Error at Data Flow Task For Test1 - test_tbl_job [OLE DB Destination [16]]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to resolve column level collations. Bulk-copy cannot continue.".

Error at Data Flow Task For Test1 - test_tbl_job [OLE DB Destination [16]]: Failed to open a fastload rowset for "testdb..tbl2". Check that the object exists in the database.

On further trial and error I found that if I remove the fast load option, it works without glitch.

Its kind of wierd though....

Any body has faced this situation?

Thanks
Karunakaran

View 5 Replies View Related

Native Exception On Column-Level In SQLCE

Nov 30, 2007

Hi,
I have developed a Smart Device Application using VB.NET 2003 on top of Windows Mobile 2003 platform which is running on Symbol PPT 8846, a model used in our construction sites for gathering data bar-coded on Pipes, trucks...etc. This application uses SQL CE as its back-end database and since its difficult to cover our sites with WI-FI coverage, most of the time the application is running offline. As for that, on a daily basis, synchronization is done in the offices before the system is released into sites. I have been doing several implementations in several projects and till now everything is running fine but until I got a native exception on exporting the data back into the server database. The server database or main database is using Fox Pro and this is what led me to build a Web Service for communication between SQL CE and Fox Pro. Anyways, going back to that mysterious exception, I did some of my intensive debug on what caused it. As a start, I went through the code line by line to check if there was a memory leak from P/Invokes; but I was shocked that the exception was raised from "SQLCEDataAdapter.Fill(Dataset)" function. First thought came to mind was to hard reset and to re-install the application but no luck. Since it was about SQLCE, I moved towards checking the data found in the SQLCE database and tried to de-fragment the data found under the table needed for export. What I mean by de-fragmenting is that I grouped the data under different classes or families and created different tables depending on these classes. Then tried exporting again and Bingo the data was exported except one record...That was so weird!! huh? (The database had 515 records)
So I went for the Query Analyzer to try to view that record but no hope, it was taking too long to view the record, I just left it for more than 15 minutes and still no response from the Analyzer...it was so strange since there was only one record in that table!!!?!!! As going further, I was so curious why this record causing that native and inability to be viewed by the Analyzer?? I did testing on the column-level of that record and found out that you can view all the columns except two : nvarchar(200) and nvarchar (20)....I was able to resolve this problem with an SQL statement to update both columns with empty or dummy values...!!!!!
But after this resolution, I really don't know how it could be controlled later on!! and why it happened??
I would be glad if anyone can give me any advise on why such problem popped out and especially on the column-level in SQL CE?? And how to overcome it?

Thanks for your time and effort,

Looking forward to hear from as soon as possible...

Just for Clarification:
.NET CF 1.0 SP3

SQLCE 2.0
were used

View 1 Replies View Related

Information For Column-Level Merge Replication

Aug 22, 2005

Please provide me a column-level merge replication in SQL Server 2005. In the SQL Sever books online, I could able to get very few informaiton about this topic. Please provide me a best practices for using this kind of conflict resolution in Merge-replication.

View 5 Replies View Related

Really Challenging Complex Column Level Processing Question

Oct 19, 2007

Hi,

I have to implement a complex algorithm that processes each row and each column.I have bunch complex steps at the end of which a table gets populated with the processed columns.

My question is as to what is the best way to do this?CLR integration or T-SQL?
Also I would appreciate any ideas as to how to go about using either approaches.

One of the steps of processing involved per column is as follows:-
1)For each column,find successive invalid values from the start of the column.Invalid value= any value <0
2)find the invalid value depth of each column(no of successive invalid values from start)
3)If after these invalid vlaues,there is a valid value and another invalid value,replace current invalid value with valid value.
ie replace invalid value only if it has a valid value above it.
4)find the column with maximum invalue value depth and delete that many rows from the table.

Here's am example:-
Suppose there are 2 columsn colA and ColB.The columns have different datatypes eg decimal,int,string etc.
For simplicity colA and colB are ints.
RowID is keeping track of the row number.

suppose colA has the following data

RowID ColA
-----------
1 0
2 -5
3 -3
4 1
5 4
6 -9
7 5
8 8

Step1)successive invalid values from start=0,-5,-3
Step2)Invalid value depth=3(because there are 3 rows from step 1)
Step3)0,-5,-3 do not have any valid value above them.But -9 has a valid value 4 above it.So replace -9 with 4.

so colA after the algo will look as follows
RowID ColA
------------
1 0
2 -5
3 -3
4 1
5 4
6 4(replaced -9 with 4)
7 5
8 8

Now do the next column colB
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 -5
8 -8

Step1)successive invalid values from start=-6,0,0,-7
Step2)depth of invalid values=4
Step3)Next invalid value -5 occurs at RowID 7
and has a valid value 8 above it.
Replace -5 with previous valid vlaue ie 8.

RowID 8 has invalid value -8 .Its previous invalid value(-5) got replaced by a valid value 8.So replace RowID8 also with value of RowID 7 ie 8

Output at the end of these steps
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 8(replaced -5 with 8)
8 8(replaced -8 with 8)

Step4:Get the maximum invalid value depth
In this case ColB had depth=4 which is greater than ColA which had dept=3.so delete 4 rows from the beginning of the table
So the table will be

RowID colA colB
----------------------------------------
5 4 4
6 4(replaced -9 with 4) 8
7 5 8 (replaced -5 with 8)
8 8 8(replaced -8 with 8)

Thanks in advance for your help

coolaqua

View 8 Replies View Related

SQL Server Admin 2014 :: Column Level Data Encryption

Jun 17, 2015

I need to encrypt some column level data in multiple tables in SQL server 2014. I've never tried encryption in SQL server 2014. How can I achieve it?

View 4 Replies View Related

A T-SQL Function To Check Column Level Data For Special Charaters

Nov 30, 2007

I need to create a function that will check data inputted by a user into a column anc check for special charaters. If any of these exist then block the insert.

Any help will be appreciated!

Paul

View 10 Replies View Related

How To Determine Which Service Pack Level Your SQL Server Is Running And Column Name Spacing Bug?

Aug 10, 2007

I have visual studio 2005 with XP home. I'm trying to find out which service pack my SQL server is running as I've been told that Service pack 2 has a few bugs.

For example ADO Applications Report a Syntax Error When Column Names Contain Spaces. This appears to be an error i am recieving. I just wanted to confirm that it is a microsoft bug rather then something Im doing wrong.
Microsoft meantions the bug here: http://support.microsoft.com/kb/264687

I've been looking everywhere. I do not have the "query analyzer window" where you can find this out as I have VS 2005. How would I find this out.

Thank you

View 6 Replies View Related

Generates Msg 107, Level 16, State 2, Line 2 - Column Prefix Does Not Exist (Oh Yes It Does.. Anyone Got A Solution ?)

Aug 8, 2007

hi All,

Following code generates error 107 (SQL Server 2000, SP3a):

SELECT

*
FROM

dbo.AssessmentItemHierarchy Parent

INNER JOIN dbo.RaterCategory

INNER JOIN dbo.RaterType

ON RaterCategory.ID = RaterType.RaterCategoryID

INNER JOIN dbo.AssessmentRater

ON AssessmentRater.RaterTypeID = RaterType.ID

INNER JOIN dbo.AssessmentItem

ON AssessmentItem.ID = Parent.ChildItemID

INNER JOIN dbo.Assessment

ON AssessmentItem.AssessmentID = Assessment.ID

INNER JOIN dbo.AssessmentResponse

ON AssessmentResponse.AssessmentItemID = AssessmentItem.ID

ON AssessmentResponse.AssessmentRaterID = AssessmentRater.ID

INNER JOIN dbo.ImageInstance

ON ImageInstance.ID = RaterType.ImageInstanceID

INNER JOIN dbo.AssessmentItem ParentGUID

ON Parent.ParentItemID = ParentGUID.ID

Error on Run:

Msg 107, Level 16, State 2, Line 2

The column prefix 'Parent' does not match with a table name or alias name used in the query.

The only work-around I have found is a rewrite of order:

SELECT

*
FROM

AssessmentItemHierarchy Parent

INNER JOIN RaterCategory

INNER JOIN RaterType

INNER JOIN AssessmentRater

INNER JOIN AssessmentItem

INNER JOIN Assessment ON AssessmentItem.AssessmentID = Assessment.ID

INNER JOIN AssessmentResponse ON AssessmentItem.ID = AssessmentResponse.AssessmentItemID

ON AssessmentRater.ID = AssessmentResponse.AssessmentRaterID

ON RaterType.ID = AssessmentRater.RaterTypeID

ON RaterCategory.ID = RaterType.RaterCategoryID

INNER JOIN ImageInstance

ON RaterType.ImageInstanceID = ImageInstance.ID

ON Parent.ChildItemID = AssessmentItem.ID

INNER JOIN AssessmentItem ParentGUID ON Parent.ParentItemID = ParentGUID.ID

Not very pretty... anyone know why I'm getting this error message with the first version of my query?

View 1 Replies View Related

Miss Match Between Column Type In A Cursor. Msg 8114, Level 16, State 5

Nov 16, 2006

hi

I have a float column . only in cursor I get a type missmatch.

does any one knows it ?

the error

Msg 8114, Level 16, State 5, Line 14

Error converting data type varchar to float.

the code

DECLARE @RON_FLOAT FLOAT

DECLARE RON_CURSOR CURSOR FOR

SELECT RON_FLOAT

FROM RON_TABLE1

OPEN RON_CURSOR

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT 'VALUE IS ' + @RON_FLOAT

FETCH NEXT FROM RON_CURSOR

INTO @RON_FLOAT

END

CLOSE RON_CURSOR

DEALLOCATE RON_CURSOR

the code for the table

CREATE TABLE [dbo].[RON_TABLE1](

[RON_FLOAT] [float] NULL,

[RON_CHAR] [nchar](10) COLLATE Hebrew_BIN NULL

)

View 1 Replies View Related

Unable To Resolve Column Level Collations. Bulk-copy Cannot Continue

May 13, 2008

Hi,

When I try to execute a package I get this following error. I have a bunch of similar packages which runs fine on the same source(sybase) and destination(sqlserver 2005), just different tables. Only few of them fails and all of them have the same error of "Unable to resolve column level collations. Bulk-copy cannot continue". I checked for the dtatatype and length between source and destination, both are same. The user have all the required rights on the objects in both source and destination.

Error at Data Flow Task For Test1 - test_tbl_job [OLE DB Destination [16]]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to resolve column level collations. Bulk-copy cannot continue.".
Error at Data Flow Task For Test1 - test_tbl_job [OLE DB Destination [16]]: Failed to open a fastload rowset for "testdb..tbl2". Check that the object exists in the database.

Some body can shed light on this?

Thanks
Karun

View 6 Replies View Related

Reporting Services :: SSRS Interactive Filter At The Column Level (Like In Excel)?

May 21, 2015

Is it possible to have Interactive Filters in an SSRS report like in Excel at Column Level as highlighted below.

View 2 Replies View Related

Column Level Constraints... I Need A Constraint, Not A Rule, Or A Trigger Or A Stored Proc... Thnx.

Jul 17, 2001

View 1 Replies View Related

SQL Security :: Enforcing Unique Constraint On A Column Encrypted With Cell Level Encryption?

May 11, 2015

I want to enforce a unique constraint on a column which must be encrypted in MSSQL 2005 using Cell Level Encyption (CLE).

    CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'itsaSECRET!!!3£3£3£!!!'
    CREATE CERTIFICATE ERCERT WITH SUBJECT = 'A cert for use by procs'
    CREATE SYMMETRIC KEY ERKEY
    WITH ALGORITHM = AES_256
    ENCRYPTION BY CERTIFICATE ERCERT

[Code] ....

The output makes it obvious why the constraint has 'not' been enforced.

        Email
       -------
    1 | 0x00703529AF46D24BA863A3534260374E01000000328909B51BA44A49510F24DF31
C46F2E30977626D96617E2BD13D9115EB578852EEBAE326B8F3E2D422230478A29767C
    2 | 0x00703529AF46D24BA863A3534260374E01000000773E06E1B53F2C57F97C54370FECBB45B
C8A154FEA5CEEB9B6BB1133305282328AAFAD65B9BDC595F0006474190F6482
    3 | 0x00703529AF46D24BA863A3534260374E01000000C9EDB1C83B52E60598038D832D34
D75867AB0ABB23F9044B7EBC76832F22C432A867078D10974DC3717D6086D3031BDB

But, how do I work around this?

View 8 Replies View Related

High Level && Detail Level Design Documents

Nov 19, 2007

Hi,
AM in need of SSRS 2005 design documents for a project purpose. Can somebody let me know where can i find these documents? Thanks in advance

View 1 Replies View Related

Matrix - Centering Higher Level Column Group Values In Viewing Area Instead Of Entire Cell Band Width

Dec 28, 2007

I have 2 higher level column groupings of month name and year above my actual date groups. It looks a little weird aligning them left but there is no guarantee that centering them will even allow them to show until I've scrolled right to the middle of the cell width that they occupy.

Is there a feature that comes with, or a well known trick for making them center in the area that is being viewed instead of the potentially very wide cell that they occupy?

View 4 Replies View Related

Transactions = Table Level Or Row Level ?

Nov 29, 2006

When you utilize transactions in ADO.NET are the locks put on the entire TABLE used or at the row level?
For instance if you do a SELECT within a transaction if you only pull 5 rows out of a 1000 row table can you just make it lock the rows that have been pulled? It seems like it locks the entire table?

Thanks

View 6 Replies View Related

What Is Low Level And High Level Locking

May 3, 2007

Hi, Can anybody please explain me, what is low level and high level locking in SQL Server 2005 database.
Also what is the name of process which converts low level locking into high level locking and vise versa.
-Sanjeev

View 2 Replies View Related

Statement Level Vs. Row Level Triggers

Jul 20, 2005

Hi..I'd very much appreciate it if someone would tell me how to translatea statement level trigger written in Oracle to its equivalent (if there isone)in MS SQL Server. Ditto for a row level trigger.If this is an old topic, I apologize. I'm very much a newbie to SQL Server.Regards,Allan M. Hart

View 2 Replies View Related

DB Corruption

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

Corruption Anyone?

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

6.5 (YES...6.5) Corruption

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

Corruption

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

SQL Corruption

Jul 20, 2005

We've a database in MSSQL. For some reason, one transaction wasinterrupted at network level. That corrupted our database. If we tryto attach it, we get the following error.Server: message 3624, level 20, state 1, line 1Location: page.cpp:2412Expression: m_slots [-m_slotCnt + 1 + i].offset == 0SPID: 51Process ID: 944connection brokenAny help will be kindregards!

View 2 Replies View Related

Index Corruption

Jan 8, 2001

We have a table with over 6 million rows. 5 fields define the primary key. Some time ago, we started receiving Integrity Check failure notifications on the indexes for the table. I attempted to "Select into" another table and rebuild the index, but the rebuild fails indicating that there are duplicate keys. How can I find the duplicate key? Any idea on how a duplicate would have been inserted in the first place?

View 1 Replies View Related