AdventureWorks Sample Database && Data Consistency

Oct 17, 2007

Hi,

I'm working with the sample database called Adventure Works and I'm encountering data consistency issues :
If I sum the TotalDue for one particular territory, for one particular time window from the Sales. SalesOrderHeader table and if I try to compare the result to the LastYearSales and YTDSales from the Sales.SalesTerritory table, I don't get the same number, whatever I try. So did I miss something ?
How are the LastYearSales and YTDSales fields from Sales.SalesTerritory calculated ?

Thx,

Anissa

View 3 Replies

Trying To Install Adventureworks Sample

Jan 4, 2006

I've downloaded from msdn and ran the samples. It installs something, but the database tree doesn't show up in sql studio. Is there a straight forward way to do something like import or restore a adventureworks database setup?

View 1 Replies View Related

Sample Files For Adventureworks SSIS

Jul 5, 2006

All,

I am very new to Sql Server and just starting in BI.

I want to do the SSIS tutorial, but even though I have been able to attach the Adventureworks DB, I can not find the flat files that are to be loaded in the tutorial. Is there some place where I can download them from?

Any other options?

Thanks for your help.

View 1 Replies View Related

Running Setup To Install AdventureWorks Sample Databases And Samples

Mar 23, 2007

Hi, i read article on how to install the AdventureWorks on my PC, basically i downloaded the sample db from microsoft website, but after i install several times, i seems cant get to see it in my sql server 2005, please assist on this, i have been craking head for this. Thanks :)

View 1 Replies View Related

Trying To Select AdventureWorks Database Data From Query Analyzer - Need Help

Jan 30, 2006

Hi there, I have installed Sql server 2005 developer on my machine which already has a Sql server 2000 installed on. Now i am trying to query the Sqlserver 2005 data(Ex: from Person.Address located in AdventureWorks database) in Sqlserver 2000 query analyzer:
When i try as Select * from Address it said invalid object.
But when i explored AdventureWorks database in the Management studio i see it as Person.Address!!! i don't understand what is a Person in Person.Address??? any clues on this?
So as a test when i ran select * from Person.Address it did work and i saw the results in query analyzer.
Can any one help me understand about this confusion?
Thanks-L

View 1 Replies View Related

AdventureWorks In Management Studio Is Gone: How To Reinstall Its Database && Data Warehouse From Script Or By Downloading

Oct 28, 2007

Hi all,
One year ago, I did "Ruuning Setup to Install AdventureWorks Sample Databases and Sample" to install "AdventureWorks" in my SQL Server Management Studio Express. Now, It just have the name "AdventureWorks" on and no contents (no tables, schemas, etc.) in it. In my Control Panel, Add or Remove Programs, AdventureWorksDB (162.00 MB) is still there and AdventureWorks (Windows Installer Package [27,992 KB]) is in my C:/drive.

(1) Should I delete the name "AdventureWorks" in my SQL Server Management Studio Express, and remove AdventureWorksDB (162.00 MB) from the Add or Remove Program, before I re-install AdventureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples from Windows Installer Package [27,992 KB]? Is my old AdventureWorks (Windows Installer Package [27,992 KB]) still good and complete for installation?
(2) SQL Server 2005 Books Online (September 2007) presents "Reinstalling Sample Databases from Script". But (i) I can not find the file instawdb.sql for reinstalling AdventureWorks from script and I do not have AdventureWorks OLTP in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder, (ii) I can not find the file instawdwdb.sql for reinstalling AdventureWorksDW from script and I do not have AdventureWorks Data Warehouse in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder either!!??
Please help and tell me what is the best way and some detailed instructions/tips to have AdvenureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples installed in my SQL Server Management Studio Express.

Thanks in advance,
Scott Chang

View 4 Replies View Related

Adding Sample Data To New Database

Jun 11, 2008

I created a database using SSMS, now I want to add sample data.

What are the methods of adding sample data from the server?

Do I need to use the SQL Server client or can I use the SQL command line or query window?

Thank you,

Goldmember

View 1 Replies View Related

Database Explorer In VB Express:AdventureWorks.mdf-Files Do Not Match The Primary File Of The Database

Nov 5, 2007

Hi all,

I downloaded and ran AdventureWorks.msi into my SQL Server Management Studio Express (SSMSE) one year ago.But I did not know how to attach it to my SSMSE then. Last week, I deleted it from the "Add or Remove" of Control Panel and I downloaded the new AdventureWork.msi and installed it my SSMSE. Today, I tried to use the Database Explorer of VB 2005 Express for the first Stored Procedure programming. I clicked on AdventureWorks.mdf and I got the following error: One or more files do not match the primary of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupt and should be restored from a backup. Cannot open user default database. Login failed. Login failed for user 'CENADe1enxshc'. Log file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data_log.ldf' does not match the primary file. It may be from a different database of the log may have been rebuilt previously. Please help and advise me how to correct this problem.

Thanks,
Scott Chang

View 9 Replies View Related

Error Attaching Adventureworks Database And SSIS Training Database

Oct 4, 2006

Hi there,

I got this error when i tried to attach the adventureworks database and SSIS training database.

an exception occurred while executing a transact-sql statement or batch
(microsoft.sqlserver.connectioninfo)

could not find row in sysindexes for database ID 17, object ID 1, index ID 1. Run DBCC
checktable on sysindexes.

I join join a network domain for my computer. Previously it doesnt have this problem.

View 1 Replies View Related

AdventureWorks Database

Mar 21, 2007

I'm interested in AdventureWorks querying. I thought of get a start from someone specifically on this db.

View 4 Replies View Related

AdventureWorks Database

Jun 3, 2007

I am unable to attach the AdventureWorks database in management studio. I installed it when I installed SQL Server 2005 but can not find the mdf or ldf files anywhere. When I inserted the installation disks again to do a custom instal, and selected AdventureWorks, the response came back that it was already installed. What do I need to do to be able to attache this db in the management studio?

Many thanks in advance for your help.

View 9 Replies View Related

AdventureWorks Database Question

Apr 6, 2006

How can I install the AdventureWorks database on my box where C:Program FilesMicrosoft SQL Server90ToolsSamples is missing? My SQL 2005 is currently without AdventureWorks OLT. I downloaded the Enterprise trial before uninstalling SQL2005Express. Please help. Thanks.

View 4 Replies View Related

Install AdventureWorks Database

Oct 8, 2007

I'm not sure that I installed the AdventureWorks database when I originally installed SQL Server 2005 on my pc, but I thought I'd better go thru the tutorial and it uses AdventureWorks, so I put my CD in to install it and started the install.

When I got to the screen where you choose your components, I only checked the Sample Database selections at the bottom. Then I got a screen saying the components had already been installed. So I thought I must have installed AdventureWorks when I did the original install, but the tutorial says to go to Registered Servers and do a new Server Registration choosing the AdventureWorks database on the Connection Properties tab. But it isn't listed there when I browse the server's databases.

How can I get it installed?

NOTE: I had SQL Server installed on my C: drive, but had a major corruption issue, so I added a second hard drive to my system and installed XP on it. So my boot drive is now by G: drive, not C:. SQL Server and most of the other programs I use have been re-installed on G:. I DO have northwind.mdb & ldb files on my C: drive. Would it be easiest to just restore them to G:? Are they the AdventureWorks database?
Thanks.

View 2 Replies View Related

Attaching AdventureWorks Database

Mar 21, 2007

Today I installed SQLEXPR.EXE that I found here:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

I made sure that I downloaded the 64-bit version.

I then wanted to download and install the Adventure Works database located here: http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

Since I am running Vista 64-bit, I downloaded and installed AdventureWorksDB_x64. It wouldn't install. I got "Access is denied" and CREATE FILE error plus several others.

I then uninstalled it and downloaded AdventureWorksDB - this is the X86 version. It installed fine.

Can anyone explain what am I missing? Thanks!

View 1 Replies View Related

Installing The AdventureWorks Database

Jul 27, 2006

I've downloaded and installed the Adventure works database

I follow the instructions give here

http://msdn2.microsoft.com/en-us/library/ms310325.aspx

but this command here:

exec sp_attach_db @dbname=N'AdventureWorks', @filename1=N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data.mdf', @filename2=N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_log.ldf'

results in this error:

"unable to open physical file,................................................. the system can't find the specified file."

AdventureWorks_log.ldf + AdventureWorks_Data.mdf ...................don't exist at this location:

c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData

i'm thinking of reinstalling the whole adventure works DB.

any ideas please

View 2 Replies View Related

Cannot Install AdventureWorks Database.

Aug 6, 2007

I downloaded AdventureWorksDB from the CodePlex website and tried to install it. When the install program tried to attach it to SQLEXPRESS, it gave the error (below). I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.

I'd never heard of having incompatible database versions for SQL Server before. Am I missing a patch for SQLEXPRESS or ????. Thanks.

=================================================================

The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)
------------------------------
Server Name: HP-MEDIACENTERSQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1

View 13 Replies View Related

Database Consistency Checker

Jan 2, 2002

Hi,

I found the databases are performance is very poor and I was told to repair the database after running consistency checker.

I presume to repair the database, it needs to be started in single user mode.

We got many databases in the dataserver being used on 24/7 basis. Could any please suggest any efficient method/way of repairing database objects(table) minimising the downtime.

Also please tell me how to start individual database in singe used mode.

Thanks in advance
John Jayaseelan

View 1 Replies View Related

Database Consistency Errors

Feb 15, 2006

Hi all,

Would appreciate your words of wisdom on the errors below. It's SQL Server 2000 SP3 on Windows 2000. We had hardware problems on one of the disks in the array the data files are on, which precipitated a number of errors in the Application Event log:

Event ID 17052,MSSQLSERVER,Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x000002ed448000 in file 'E:SQLDATA2XDB_Data.MDF'.

Running DBCC CHECKDB resulted in the following:

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1901458048, index ID 0: Page (1:1534500) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 0, page (1:1534500). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
DBCC results for 'XDB'.
DBCC results for 'sysobjects'.
There are 328 rows in 18 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 843 rows in 56 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 4018 rows in 98 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.

<snip lots more successful checks>

DBCC results for 'tblXMLListsRecords'.
There are 3302391 rows in 79187 pages for object 'tblXMLListsRecords'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
DBCC results for 'tblPhotosFolder'.
There are 6121 rows in 228 pages for object 'tblPhotosFolder'.
DBCC results for 'tblImageUpload'.
There are 5 rows in 1 pages for object 'tblImageUpload'.
DBCC results for 'tblLogs'.
There are 2049298 rows in 50892 pages for object 'tblLogs'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'XDB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XDB ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

So the questions are - what does the first error mean (the table error)? And does a report of 2 consistency errors in tblXMLListRecords mean that we will lose two records? We have a backup but it would mean losing today's work if we went back to it - admittedly not much, but I'd like to be able to make an informed choice as to whether repairing the database or restoring it would be favourite. Any thoughts gratefully received!

I've also taken a backup of the corrupted database, restored it to another server and run
DBCC CHECKDB ('XDB',REPAIR_ALLOW_DATA_LOSS) with the following results. So now I'm thinking restoring from backup is probably best after all - correct?

DBCC results for 'XDB'.
DBCC results for 'sysobjects'.
There are 329 rows in 18 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 843 rows in 56 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 4018 rows in 95 pages for object 'syscolumns'.

<snip successful checks>

DBCC results for 'tblMenus'.
There are 0 rows in 1 pages for object 'tblMenus'.
DBCC results for 'tblImageProcessingFilenames'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1901458048, index ID 0: Page (1:1534500) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 0, page (1:1534500). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 1. Page (1:1180423) is missing a reference from previous page (1:1534500). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1901458048, index ID 1. Page (1:1534500) was not seen in the scan although its parent (1:1243134) and previous (1:1232752) refer to it. Check any previous errors.
There are 687 rows in 188 pages for object 'tblImageProcessingFilenames'.
DBCC results for 'tblData15C69B09E60A4DC5B19D8C8BD69E6C15'.
There are 842 rows in 23 pages for object 'tblData15C69B09E60A4DC5B19D8C8BD69E6C15'.
DBCC results for 'tblDataLinksChild15C69B09E60A4DC5B19D8C8BD69E6C15'.
There are 848 rows in 24 pages for object 'tblDataLinksChild15C69B09E60A4DC5B19D8C8BD69E6C15'.
DBCC results for 'tblUpdateFields'.
There are 1 rows in 3 pages for object 'tblUpdateFields'.
DBCC results for 'tblData1FDBC8FBD862435E8AD7C648F37F6D3A'.
There are 5 rows in 1 pages for object 'tblData1FDBC8FBD862435E8AD7C648F37F6D3A'.
DBCC results for 'tblDataLinksChild1FDBC8FBD862435E8AD7C648F37F6D3A'.
There are 5 rows in 1 pages for object 'tblDataLinksChild1FDBC8FBD862435E8AD7C648F37F6D3A'.
DBCC results for 'tblXML031029'.
There are 83683 rows in 3331 pages for object 'tblXML031029'.
DBCC results for 'tblXMLListsRecords'.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Repair: Page (1:1534500) has been deallocated from object ID 1901458048, index ID 0.
Clustered index successfully restored for object 'dbo.tblXMLListsRecords' in database 'XDB'.
There are 3302279 rows in 79187 pages for object 'tblXMLListsRecords'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
CHECKDB fixed 0 allocation errors and 4 consistency errors in table 'tblXMLListsRecords' (object ID 1901458048).
DBCC results for 'tblPhotosFolder'.
There are 6109 rows in 224 pages for object 'tblPhotosFolder'.
DBCC results for 'tblImageUpload'.
There are 5 rows in 1 pages for object 'tblImageUpload'.
DBCC results for 'tblLogs'.
There are 2048554 rows in 50870 pages for object 'tblLogs'.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'XDB'.
CHECKDB fixed 0 allocation errors and 4 consistency errors in database 'XDB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Please let me know if there is anything else I should post - many thanks in advance.

View 2 Replies View Related

Getting Rid Of Consistency Errors In Database

Aug 1, 2007

We've got the following error when we ran the "DBCC CHECKDB WITH ALL_ERRORMSGS" command. Please advise what would be the best method to fix this problem without lossing any data (if possible).

--------------

DBCC results for 'PRODUCTION'.
DBCC results for 'sysobjects'.
There are 314 rows in 7 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 361 rows in 15 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1009 rows in 15 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 153 rows in 19 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 153 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 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 353 rows in 2 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 62 rows in 1 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 'MHGROUP.CUSTOM1'.
There are 17010 rows in 107 pages for object 'MHGROUP.CUSTOM1'.
DBCC results for 'MHGROUP.FORMS'.
There are 12 rows in 1 pages for object 'MHGROUP.FORMS'.
DBCC results for 'MHGROUP.CUSTOM2'.
There are 161612 rows in 1495 pages for object 'MHGROUP.CUSTOM2'.
DBCC results for 'MHGROUP.DOCCACHE'.
There are 0 rows in 0 pages for object 'MHGROUP.DOCCACHE'.
DBCC results for 'MHGROUP.FORM_CONTROLS'.
There are 579 rows in 7 pages for object 'MHGROUP.FORM_CONTROLS'.
DBCC results for 'MHGROUP.CUSTOM3'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM3'.
DBCC results for 'MHGROUP.QUICK_RETRIEVE'.
There are 15656 rows in 131 pages for object 'MHGROUP.QUICK_RETRIEVE'.
DBCC results for 'MHGROUP.CUSTOM4'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM4'.
DBCC results for 'MHGROUP.ROLES'.
There are 5 rows in 1 pages for object 'MHGROUP.ROLES'.
DBCC results for 'MHGROUP.CUSTOM5'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM5'.
DBCC results for 'MHGROUP.USERROLES'.
There are 4 rows in 1 pages for object 'MHGROUP.USERROLES'.
DBCC results for 'MHGROUP.CUSTOM6'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM6'.
DBCC results for 'MHGROUP.KEYWORDS'.
There are 0 rows in 0 pages for object 'MHGROUP.KEYWORDS'.
DBCC results for 'MHGROUP.CUSTOM7'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM7'.
DBCC results for 'MHGROUP.DOC_KEYWORDS'.
There are 0 rows in 0 pages for object 'MHGROUP.DOC_KEYWORDS'.
DBCC results for 'MHGROUP.ROLE_PROFILES'.
There are 182 rows in 2 pages for object 'MHGROUP.ROLE_PROFILES'.
DBCC results for 'MHGROUP.CUSTOM8'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM8'.
DBCC results for 'MHGROUP.SECURITY_TEMPLATE'.
There are 1 rows in 1 pages for object 'MHGROUP.SECURITY_TEMPLATE'.
DBCC results for 'MHGROUP.CUSTOM9'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM9'.
DBCC results for 'MHGROUP.SYSTEM_PREFERENCES'.
There are 7 rows in 1 pages for object 'MHGROUP.SYSTEM_PREFERENCES'.
DBCC results for 'MHGROUP.CUSTOM10'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM10'.
DBCC results for 'MHGROUP.USER_PREFERENCES'.
There are 0 rows in 0 pages for object 'MHGROUP.USER_PREFERENCES'.
DBCC results for 'MHGROUP.USR_SCTY_ACC_TEMP'.
There are 1 rows in 1 pages for object 'MHGROUP.USR_SCTY_ACC_TEMP'.
DBCC results for 'MHGROUP.CUSTOM11'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM11'.
DBCC results for 'MHGROUP.CUSTOM12'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM12'.
DBCC results for 'MHGROUP.GRP_SCTY_ACC_TEMP'.
There are 1 rows in 1 pages for object 'MHGROUP.GRP_SCTY_ACC_TEMP'.
DBCC results for 'MHGROUP.CUSTOM29'.
There are 14 rows in 1 pages for object 'MHGROUP.CUSTOM29'.
DBCC results for 'MHGROUP.CUSTOM30'.
There are 131 rows in 3 pages for object 'MHGROUP.CUSTOM30'.
DBCC results for 'MHGROUP.USR_SCTY_TEMP_ASSC'.
There are 1 rows in 1 pages for object 'MHGROUP.USR_SCTY_TEMP_ASSC'.
DBCC results for 'MHGROUP.CUSTOM31'.
There are 0 rows in 0 pages for object 'MHGROUP.CUSTOM31'.
DBCC results for 'MHGROUP.USERACTIONS'.
There are 4 rows in 1 pages for object 'MHGROUP.USERACTIONS'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190233706496 owned by data record identified by RID = (1:70653:1) EDITWHEN = May 3 2007 12:42AM and DOCNUM = 438753 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 249893486592 owned by data record identified by RID = (1:78576:3) EDITWHEN = May 3 2007 4:04AM and DOCNUM = 547171 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 226056470528 owned by data record identified by RID = (1:79561:4) EDITWHEN = May 3 2007 4:34AM and DOCNUM = 506724 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250617135104 owned by data record identified by RID = (1:93581:0) EDITWHEN = May 7 2007 8:56AM and DOCNUM = 300158 and VERSION = 41.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 148611661824 owned by data record identified by RID = (1:97144:1) EDITWHEN = May 8 2007 8:48AM and DOCNUM = 371047 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247374348288 owned by data record identified by RID = (1:101411:1) EDITWHEN = May 9 2007 8:53AM and DOCNUM = 542832 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251084603392 owned by data record identified by RID = (1:103097:4) EDITWHEN = May 10 2007 3:39AM and DOCNUM = 549268 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183028940800 owned by data record identified by RID = (1:104120:0) EDITWHEN = May 10 2007 9:04AM and DOCNUM = 429670 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 10331947008 owned by data record identified by RID = (1:105331:1) EDITWHEN = May 11 2007 3:41AM and DOCNUM = 84626 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251640938496 owned by data record identified by RID = (1:108119:7) EDITWHEN = May 14 2007 4:34AM and DOCNUM = 550202 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252161425408 owned by data record identified by RID = (1:116159:0) EDITWHEN = May 16 2007 8:09AM and DOCNUM = 551368 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252471803904 owned by data record identified by RID = (1:120284:4) EDITWHEN = May 18 2007 2:02AM and DOCNUM = 551970 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250536984576 owned by data record identified by RID = (1:122958:2) EDITWHEN = May 18 2007 8:20AM and DOCNUM = 548281 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 206225408000 owned by data record identified by RID = (1:123289:0) EDITWHEN = May 18 2007 10:14AM and DOCNUM = 449652 and VERSION = 8.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252530786304 owned by data record identified by RID = (1:123815:1) EDITWHEN = May 21 2007 2:29AM and DOCNUM = 552102 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 58982203392 owned by data record identified by RID = (1:125063:1) EDITWHEN = May 21 2007 6:42AM and DOCNUM = 197503 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250440187904 owned by data record identified by RID = (1:125578:10) EDITWHEN = May 21 2007 9:52AM and DOCNUM = 548097 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252884549632 owned by data record identified by RID = (1:126217:3) EDITWHEN = May 21 2007 10:37AM and DOCNUM = 552814 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252885336064 owned by data record identified by RID = (1:126217:4) EDITWHEN = May 21 2007 10:37AM and DOCNUM = 552823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252898705408 owned by data record identified by RID = (1:126371:0) EDITWHEN = May 21 2007 1:49PM and DOCNUM = 552720 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252899229696 owned by data record identified by RID = (1:126371:2) EDITWHEN = May 21 2007 1:52PM and DOCNUM = 552738 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252677914624 owned by data record identified by RID = (1:126371:4) EDITWHEN = May 21 2007 2:06PM and DOCNUM = 552331 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252900016128 owned by data record identified by RID = (1:126371:6) EDITWHEN = May 21 2007 2:36PM and DOCNUM = 552842 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 246325903360 owned by data record identified by RID = (1:126371:7) EDITWHEN = May 21 2007 2:40PM and DOCNUM = 541091 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251883880448 owned by data record identified by RID = (1:126371:8) EDITWHEN = May 21 2007 2:49PM and DOCNUM = 522753 and VERSION = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 117782872064 owned by data record identified by RID = (1:126447:2) EDITWHEN = May 22 2007 1:22AM and DOCNUM = 316151 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 164379951104 owned by data record identified by RID = (1:126447:3) EDITWHEN = May 22 2007 1:22AM and DOCNUM = 397610 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183754752000 owned by data record identified by RID = (1:127392:0) EDITWHEN = May 22 2007 1:28AM and DOCNUM = 430878 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 166120128512 owned by data record identified by RID = (1:127392:1) EDITWHEN = May 22 2007 1:29AM and DOCNUM = 400652 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252898705408 owned by data record identified by RID = (1:127392:3) EDITWHEN = May 22 2007 1:30AM and DOCNUM = 552720 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 229398937600 owned by data record identified by RID = (1:127393:0) EDITWHEN = May 22 2007 1:31AM and DOCNUM = 511737 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252900016128 owned by data record identified by RID = (1:127393:1) EDITWHEN = May 22 2007 1:31AM and DOCNUM = 552842 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251084603392 owned by data record identified by RID = (1:127395:2) EDITWHEN = May 22 2007 1:40AM and DOCNUM = 549268 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 204838666240 owned by data record identified by RID = (1:127398:0) EDITWHEN = May 22 2007 1:55AM and DOCNUM = 469609 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 148611661824 owned by data record identified by RID = (1:127824:1) EDITWHEN = May 22 2007 2:00AM and DOCNUM = 371047 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 58982203392 owned by data record identified by RID = (1:127825:2) EDITWHEN = May 22 2007 2:06AM and DOCNUM = 197503 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 195948838912 owned by data record identified by RID = (1:127826:1) EDITWHEN = May 22 2007 2:14AM and DOCNUM = 453377 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 2315714560 owned by data record identified by RID = (1:127830:4) EDITWHEN = May 22 2007 2:42AM and DOCNUM = 49333 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 219683880960 owned by data record identified by RID = (1:127831:2) EDITWHEN = May 22 2007 2:44AM and DOCNUM = 446037 and VERSION = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 136499429376 owned by data record identified by RID = (1:127831:4) EDITWHEN = May 22 2007 2:45AM and DOCNUM = 351353 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 97868775424 owned by data record identified by RID = (1:127992:4) EDITWHEN = May 22 2007 2:47AM and DOCNUM = 277606 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 108305776640 owned by data record identified by RID = (1:127996:1) EDITWHEN = May 22 2007 2:57AM and DOCNUM = 297781 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 246325903360 owned by data record identified by RID = (1:127996:2) EDITWHEN = May 22 2007 2:58AM and DOCNUM = 541091 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 208979886080 owned by data record identified by RID = (1:127996:3) EDITWHEN = May 22 2007 3:02AM and DOCNUM = 477254 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211872514048 owned by data record identified by RID = (1:127996:5) EDITWHEN = May 22 2007 3:02AM and DOCNUM = 479398 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 73371942912 owned by data record identified by RID = (1:127998:0) EDITWHEN = May 22 2007 3:07AM and DOCNUM = 228381 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 226056470528 owned by data record identified by RID = (1:127999:1) EDITWHEN = May 22 2007 3:17AM and DOCNUM = 506724 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 180270596096 owned by data record identified by RID = (1:128064:3) EDITWHEN = May 22 2007 3:18AM and DOCNUM = 424808 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 153409421312 owned by data record identified by RID = (1:128065:1) EDITWHEN = May 22 2007 3:19AM and DOCNUM = 378903 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 176867508224 owned by data record identified by RID = (1:128068:0) EDITWHEN = May 22 2007 3:33AM and DOCNUM = 418823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 127582076928 owned by data record identified by RID = (1:128068:1) EDITWHEN = May 22 2007 3:33AM and DOCNUM = 335751 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 41496477696 owned by data record identified by RID = (1:128070:1) EDITWHEN = May 22 2007 3:44AM and DOCNUM = 160458 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252530786304 owned by data record identified by RID = (1:128070:4) EDITWHEN = May 22 2007 3:45AM and DOCNUM = 552102 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250617135104 owned by data record identified by RID = (1:128070:6) EDITWHEN = May 22 2007 3:49AM and DOCNUM = 300158 and VERSION = 41.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 213345239040 owned by data record identified by RID = (1:128071:2) EDITWHEN = May 22 2007 3:50AM and DOCNUM = 484473 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211040141312 owned by data record identified by RID = (1:128240:2) EDITWHEN = May 22 2007 3:54AM and DOCNUM = 480799 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 215276191744 owned by data record identified by RID = (1:128241:2) EDITWHEN = May 22 2007 3:58AM and DOCNUM = 484020 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 227707453440 owned by data record identified by RID = (1:128245:3) EDITWHEN = May 22 2007 4:08AM and DOCNUM = 509645 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17572626432 owned by data record identified by RID = (1:128245:5) EDITWHEN = May 22 2007 4:09AM and DOCNUM = 104597 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190558240768 owned by data record identified by RID = (1:128247:3) EDITWHEN = May 22 2007 4:15AM and DOCNUM = 443514 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 233244852224 owned by data record identified by RID = (1:128392:5) EDITWHEN = May 22 2007 4:18AM and DOCNUM = 518211 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 236761710592 owned by data record identified by RID = (1:128395:0) EDITWHEN = May 22 2007 4:27AM and DOCNUM = 135768 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4776329216 owned by data record identified by RID = (1:128396:0) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 67067 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4781637632 owned by data record identified by RID = (1:128396:1) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 67147 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 57178390528 owned by data record identified by RID = (1:128396:2) EDITWHEN = May 22 2007 4:31AM and DOCNUM = 193517 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132154130432 owned by data record identified by RID = (1:128397:1) EDITWHEN = May 22 2007 4:36AM and DOCNUM = 343930 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 181863710720 owned by data record identified by RID = (1:128399:3) EDITWHEN = May 22 2007 4:43AM and DOCNUM = 427662 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 157604446208 owned by data record identified by RID = (1:128399:4) EDITWHEN = May 22 2007 4:44AM and DOCNUM = 385594 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 53393555456 owned by data record identified by RID = (1:128512:0) EDITWHEN = May 22 2007 4:47AM and DOCNUM = 185489 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 249893486592 owned by data record identified by RID = (1:128544:2) EDITWHEN = May 22 2007 6:01AM and DOCNUM = 547171 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252885336064 owned by data record identified by RID = (1:131422:1) EDITWHEN = May 23 2007 4:54AM and DOCNUM = 552823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4781637632 owned by data record identified by RID = (1:217589:1) EDITWHEN = Jan 30 2002 2:45PM and DOCNUM = 67147 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 2315714560 owned by data record identified by RID = (1:217981:11) EDITWHEN = Apr 19 2002 5:22AM and DOCNUM = 49333 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190233706496 owned by data record identified by RID = (1:226945:0) EDITWHEN = May 26 2007 2:04AM and DOCNUM = 438753 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 97868775424 owned by data record identified by RID = (1:231817:5) EDITWHEN = Oct 11 2004 5:51PM and DOCNUM = 277606 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17055547392 owned by data record identified by RID = (1:232186:10) EDITWHEN = Oct 26 2004 3:22PM and DOCNUM = 103068 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247127146496 owned by data record identified by RID = (1:234352:0) EDITWHEN = May 28 2007 8:01AM and DOCNUM = 542357 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 117782872064 owned by data record identified by RID = (1:235268:9) EDITWHEN = Mar 4 2005 3:41PM and DOCNUM = 316151 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17572626432 owned by data record identified by RID = (1:237531:0) EDITWHEN = Jun 9 2005 11:48AM and DOCNUM = 104597 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 108305776640 owned by data record identified by RID = (1:237547:6) EDITWHEN = Jun 9 2005 6:03PM and DOCNUM = 297781 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132154130432 owned by data record identified by RID = (1:239829:14) EDITWHEN = Sep 17 2005 12:07PM and DOCNUM = 343930 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 153409421312 owned by data record identified by RID = (1:240034:13) EDITWHEN = Sep 26 2005 7:07AM and DOCNUM = 378903 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250536984576 owned by data record identified by RID = (1:241157:1) EDITWHEN = May 29 2007 8:07AM and DOCNUM = 548281 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 53393555456 owned by data record identified by RID = (1:241754:16) EDITWHEN = Oct 26 2005 8:13AM and DOCNUM = 185489 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252471803904 owned by data record identified by RID = (1:243337:1) EDITWHEN = May 31 2007 7:23AM and DOCNUM = 551970 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 164379951104 owned by data record identified by RID = (1:245986:11) EDITWHEN = Dec 8 2005 8:10AM and DOCNUM = 397610 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 166120128512 owned by data record identified by RID = (1:246003:5) EDITWHEN = Dec 9 2005 3:55AM and DOCNUM = 400652 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183028940800 owned by data record identified by RID = (1:246096:0) EDITWHEN = Jun 5 2007 3:19AM and DOCNUM = 429670 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251883880448 owned by data record identified by RID = (1:247655:2) EDITWHEN = Jun 6 2007 10:08AM and DOCNUM = 522753 and VERSION = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252884549632 owned by data record identified by RID = (1:248826:4) EDITWHEN = Jun 7 2007 11:59AM and DOCNUM = 552814 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 136499429376 owned by data record identified by RID = (1:251952:13) EDITWHEN = Feb 17 2006 10:57AM and DOCNUM = 351353 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 251640938496 owned by data record identified by RID = (1:252074:1) EDITWHEN = Jun 13 2007 12:54AM and DOCNUM = 550202 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 178253660160 owned by data record identified by RID = (1:252644:5) EDITWHEN = Jun 13 2007 10:49AM and DOCNUM = 421231 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 157604446208 owned by data record identified by RID = (1:253275:6) EDITWHEN = Feb 24 2006 11:58AM and DOCNUM = 385594 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 178253660160 owned by data record identified by RID = (1:253835:11) EDITWHEN = Mar 7 2006 6:35PM and DOCNUM = 421231 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 183754752000 owned by data record identified by RID = (1:254587:12) EDITWHEN = Apr 4 2006 2:11PM and DOCNUM = 430878 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 181863710720 owned by data record identified by RID = (1:254770:13) EDITWHEN = Apr 13 2006 10:45AM and DOCNUM = 427662 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 127582076928 owned by data record identified by RID = (1:255302:1) EDITWHEN = Apr 27 2006 3:33PM and DOCNUM = 335751 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 243133972480 owned by data record identified by RID = (1:256195:3) EDITWHEN = Jun 18 2007 1:37AM and DOCNUM = 535717 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 180270596096 owned by data record identified by RID = (1:256497:3) EDITWHEN = May 24 2006 12:06PM and DOCNUM = 424808 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 176867508224 owned by data record identified by RID = (1:256516:2) EDITWHEN = May 24 2006 3:20PM and DOCNUM = 418823 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132764663808 owned by data record identified by RID = (1:259424:0) EDITWHEN = Jun 21 2007 2:01AM and DOCNUM = 322854 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 235844730880 owned by data record identified by RID = (1:260029:0) EDITWHEN = Jun 21 2007 9:19AM and DOCNUM = 522982 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 70246727680 owned by data record identified by RID = (1:263169:1) EDITWHEN = Jun 15 2006 5:05PM and DOCNUM = 218997 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252161425408 owned by data record identified by RID = (1:267150:1) EDITWHEN = Jun 29 2007 2:17AM and DOCNUM = 551368 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 250440187904 owned by data record identified by RID = (1:268884:1) EDITWHEN = Jul 3 2007 7:07AM and DOCNUM = 548097 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252899229696 owned by data record identified by RID = (1:268887:3) EDITWHEN = Jul 3 2007 7:19AM and DOCNUM = 552738 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247374348288 owned by data record identified by RID = (1:269197:6) EDITWHEN = Jul 4 2007 2:47AM and DOCNUM = 542832 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 70246727680 owned by data record identified by RID = (1:273514:4) EDITWHEN = Jul 11 2007 4:26AM and DOCNUM = 218997 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 17055547392 owned by data record identified by RID = (1:273514:5) EDITWHEN = Jul 11 2007 4:27AM and DOCNUM = 103068 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 190558240768 owned by data record identified by RID = (1:278155:8) EDITWHEN = Jul 27 2006 3:49PM and DOCNUM = 443514 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 225814315008 owned by data record identified by RID = (1:279369:10) EDITWHEN = Jul 20 2007 3:30AM and DOCNUM = 506132 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 206225408000 owned by data record identified by RID = (1:281667:3) EDITWHEN = Jul 23 2007 3:23AM and DOCNUM = 449652 and VERSION = 8.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 248579358720 owned by data record identified by RID = (1:283210:3) EDITWHEN = Jul 25 2007 3:41AM and DOCNUM = 544720 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 252677914624 owned by data record identified by RID = (1:285801:6) EDITWHEN = Jul 29 2007 7:05AM and DOCNUM = 552331 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247185997824 owned by data record identified by RID = (1:286463:3) EDITWHEN = Jul 30 2007 9:40AM and DOCNUM = 525566 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 10331947008 owned by data record identified by RID = (1:286858:8) EDITWHEN = Jul 31 2007 1:52AM and DOCNUM = 84626 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 71545126912 owned by data record identified by RID = (1:286860:10) EDITWHEN = Jul 31 2007 2:01AM and DOCNUM = 224547 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 204838666240 owned by data record identified by RID = (1:288739:4) EDITWHEN = Aug 28 2006 2:44PM and DOCNUM = 469609 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 132764663808 owned by data record identified by RID = (1:290973:5) EDITWHEN = Sep 7 2006 3:55PM and DOCNUM = 322854 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 41496477696 owned by data record identified by RID = (1:291224:7) EDITWHEN = Sep 14 2006 2:26PM and DOCNUM = 160458 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211872514048 owned by data record identified by RID = (1:294648:6) EDITWHEN = Sep 22 2006 9:49AM and DOCNUM = 479398 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 73371942912 owned by data record identified by RID = (1:301158:8) EDITWHEN = Oct 2 2006 4:06PM and DOCNUM = 228381 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 215276191744 owned by data record identified by RID = (1:303316:6) EDITWHEN = Oct 6 2006 5:04PM and DOCNUM = 484020 and VERSION = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 208979886080 owned by data record identified by RID = (1:303334:1) EDITWHEN = Oct 9 2006 11:20AM and DOCNUM = 477254 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 219683880960 owned by data record identified by RID = (1:307749:6) EDITWHEN = Nov 3 2006 2:36PM and DOCNUM = 446037 and VERSION = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 71545126912 owned by data record identified by RID = (1:308015:17) EDITWHEN = Nov 15 2006 12:54PM and DOCNUM = 224547 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 225814315008 owned by data record identified by RID = (1:308666:16) EDITWHEN = Dec 11 2006 3:46PM and DOCNUM = 506132 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 195948838912 owned by data record identified by RID = (1:309091:7) EDITWHEN = Dec 19 2006 3:15PM and DOCNUM = 453377 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 211040141312 owned by data record identified by RID = (1:309183:7) EDITWHEN = Dec 26 2006 7:56AM and DOCNUM = 480799 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 235844730880 owned by data record identified by RID = (1:310481:14) EDITWHEN = Feb 12 2007 1:57AM and DOCNUM = 522982 and VERSION = 1.
DBCC results for 'MHGROUP.ARCHIVETBL'.
There are 0 rows in 0 pages for object 'MHGROUP.ARCHIVETBL'.
DBCC results for 'MHGROUP.USERHISTORY'.
There are 3325 rows in 37 pages for object 'MHGROUP.USERHISTORY'.
DBCC results for 'MHGROUP.RESTORETBL'.
There are 0 rows in 0 pages for object 'MHGROUP.RESTORETBL'.
DBCC results for 'MHGROUP.DOCMASTER'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 229398937600 owned by data record identified by RID = (1:310481:15) EDITWHEN = Feb 12 2007 1:58AM and DOCNUM = 511737 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 236761710592 owned by data record identified by RID = (1:310531:3) EDITWHEN = Feb 13 2007 2:40AM and DOCNUM = 135768 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 57178390528 owned by data record identified by RID = (1:310908:12) EDITWHEN = Feb 28 2007 12:48AM and DOCNUM = 193517 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 4776329216 owned by data record identified by RID = (1:310908:14) EDITWHEN = Feb 28 2007 12:51AM and DOCNUM = 67067 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 213345239040 owned by data record identified by RID = (1:311313:12) EDITWHEN = Mar 8 2007 7:40AM and DOCNUM = 484473 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 243133972480 owned by data record identified by RID = (1:312159:4) EDITWHEN = Mar 28 2007 3:04AM and DOCNUM = 535717 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 227707453440 owned by data record identified by RID = (1:312868:1) EDITWHEN = Apr 12 2007 4:05AM and DOCNUM = 509645 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247127146496 owned by data record identified by RID = (1:312967:13) EDITWHEN = Apr 16 2007 2:48AM and DOCNUM = 542357 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 248579358720 owned by data record identified by RID = (1:313311:12) EDITWHEN = Apr 23 2007 11:26AM and DOCNUM = 544720 and VERSION = 1.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 247185997824 owned by data record identified by RID = (1:313312:12) EDITWHEN = Apr 23 2007 11:31AM and DOCNUM = 525566 and VERSION = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 597577167: Errors found in text ID 233244852224 owned by data record identified by RID = (1:313352:10) EDITWHEN = Apr 24 2007 6:03AM and DOCNUM = 518211 and VERSION = 1.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 4. The previous link (1:321250) on page (1:321251) does not match the previous page (1:128129) that the parent (1:92152), slot 9 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 4. B-tree chain linkage mismatch. (1:128129)->next = (1:321251), but (1:321251)->Prev = (1:321250).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The previous link (1:417102) on page (1:122442) does not match the previous page (1:127506) that the parent (1:321964), slot 59 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. B-tree chain linkage mismatch. (1:127506)->next = (1:122442), but (1:122442)->Prev = (1:417102).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. Parent node for page (1:127505) was not encountered.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:282065) (level 0) is not less than the low key value in the parent (1:127505), slot 0 of the next page (1:417545).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:282065) (level 0) is not less than the low key value in the parent (1:127505), slot 0 of the next page (1:417545).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The high key value on page (1:417467) (level 1) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:127505).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 22. The previous link (1:127505) on page (1:417624) does not match the previous page (1:417467) that the parent (1:416972), slot 8 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. The high key value on page (1:127753) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:436964).
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. B-tree chain linkage mismatch. (1:127754)->next = (1:436791), but (1:436791)->Prev = (1:436790).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. The previous link (1:436963) on page (1:436964) does not match the previous page (1:127753) that the parent (1:85406), slot 106 expects for this page.
Server: Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 597577167, index ID 27. B-tree chain linkage mismatch. (1:127753)->next = (1:436964), but (1:436964)->Prev = (1:436963).
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:1760), slot 4, text ID 70246727680 is pointed to by page (1:273514), slot 4 and by page (1:263169), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:2057), slot 84, text ID 153409421312 is pointed to by page (1:240034), slot 13 and by page (1:128065), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:2172), slot 86, text ID 71545126912 is pointed to by page (1:286860), slot 10 and by page (1:308015), slot 17.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:6160), slot 48, text ID 148611661824 is pointed to by page (1:127824), slot 1 and by page (1:97144), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:6328), slot 19, text ID 229398937600 is pointed to by page (1:127393), slot 0 and by page (1:310481), slot 15.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:8822), slot 59, text ID 132154130432 is pointed to by page (1:128397), slot 1 and by page (1:239829), slot 14.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:12815), slot 81, text ID 53393555456 is pointed to by page (1:241754), slot 16 and by page (1:128512), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:16730), slot 87, text ID 97868775424 is pointed to by page (1:231817), slot 5 and by page (1:127992), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:17759), slot 86, text ID 2315714560 is pointed to by page (1:217981), slot 11 and by page (1:127830), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:26744), slot 8, text ID 4776329216 is pointed to by page (1:310908), slot 14 and by page (1:128396), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:26744), slot 88, text ID 4781637632 is pointed to by page (1:128396), slot 1 and by page (1:217589), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:28388), slot 88, text ID 108305776640 is pointed to by page (1:127996), slot 1 and by page (1:237547), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:31464), slot 24, text ID 176867508224 is pointed to by page (1:128068), slot 0 and by page (1:256516), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:31467), slot 15, text ID 127582076928 is pointed to by page (1:128068), slot 1 and by page (1:255302), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:36278), slot 28, text ID 117782872064 is pointed to by page (1:126447), slot 2 and by page (1:235268), slot 9.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:43582), slot 44, text ID 251640938496 is pointed to by page (1:108119), slot 7 and by page (1:252074), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:44314), slot 4, text ID 10331947008 is pointed to by page (1:286858), slot 8 and by page (1:105331), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:45037), slot 52, text ID 132764663808 is pointed to by page (1:259424), slot 0 and by page (1:290973), slot 5.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:47759), slot 61, text ID 211872514048 is pointed to by page (1:127996), slot 5 and by page (1:294648), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:55853), slot 51, text ID 251883880448 is pointed to by page (1:247655), slot 2 and by page (1:126371), slot 8.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:56802), slot 2, text ID 236761710592 is pointed to by page (1:310531), slot 3 and by page (1:128395), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:57600), slot 69, text ID 249893486592 is pointed to by page (1:128544), slot 2 and by page (1:78576), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:58994), slot 65, text ID 252161425408 is pointed to by page (1:267150), slot 1 and by page (1:116159), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:60464), slot 49, text ID 166120128512 is pointed to by page (1:246003), slot 5 and by page (1:127392), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:63176), slot 68, text ID 190558240768 is pointed to by page (1:128247), slot 3 and by page (1:278155), slot 8.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:64153), slot 44, text ID 183028940800 is pointed to by page (1:246096), slot 0 and by page (1:104120), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:66227), slot 57, text ID 213345239040 is pointed to by page (1:311313), slot 12 and by page (1:128071), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:68734), slot 32, text ID 17055547392 is pointed to by page (1:273514), slot 5 and by page (1:232186), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69921), slot 3, text ID 252471803904 is pointed to by page (1:243337), slot 1 and by page (1:120284), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69921), slot 36, text ID 252530786304 is pointed to by page (1:128070), slot 4 and by page (1:123815), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:69925), slot 14, text ID 252677914624 is pointed to by page (1:285801), slot 6 and by page (1:126371), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:70435), slot 84, text ID 17572626432 is pointed to by page (1:128245), slot 5 and by page (1:237531), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73290), slot 72, text ID 157604446208 is pointed to by page (1:128399), slot 4 and by page (1:253275), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 44, text ID 252884549632 is pointed to by page (1:126217), slot 3 and by page (1:248826), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 45, text ID 252885336064 is pointed to by page (1:126217), slot 4 and by page (1:131422), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 65, text ID 252898705408 is pointed to by page (1:127392), slot 3 and by page (1:126371), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73412), slot 66, text ID 252900016128 is pointed to by page (1:127393), slot 1 and by page (1:126371), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:73413), slot 11, text ID 252899229696 is pointed to by page (1:268887), slot 3 and by page (1:126371), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82724), slot 41, text ID 250440187904 is pointed to by page (1:268884), slot 1 and by page (1:125578), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82726), slot 41, text ID 250617135104 is pointed to by page (1:128070), slot 6 and by page (1:93581), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:82727), slot 23, text ID 250536984576 is pointed to by page (1:241157), slot 1 and by page (1:122958), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:91947), slot 44, text ID 136499429376 is pointed to by page (1:251952), slot 13 and by page (1:127831), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:93297), slot 87, text ID 219683880960 is pointed to by page (1:127831), slot 2 and by page (1:307749), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100224), slot 14, text ID 251084603392 is pointed to by page (1:103097), slot 4 and by page (1:127395), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100592), slot 0, text ID 248579358720 is pointed to by page (1:283210), slot 3 and by page (1:313311), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:100971), slot 86, text ID 164379951104 is pointed to by page (1:126447), slot 3 and by page (1:245986), slot 11.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:104784), slot 45, text ID 73371942912 is pointed to by page (1:301158), slot 8 and by page (1:127998), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:113944), slot 40, text ID 183754752000 is pointed to by page (1:127392), slot 0 and by page (1:254587), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:129608), slot 19, text ID 247127146496 is pointed to by page (1:312967), slot 13 and by page (1:234352), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:129608), slot 62, text ID 247185997824 is pointed to by page (1:286463), slot 3 and by page (1:313312), slot 12.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:130151), slot 6, text ID 247374348288 is pointed to by page (1:269197), slot 6 and by page (1:101411), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:143138), slot 76, text ID 233244852224 is pointed to by page (1:128392), slot 5 and by page (1:313352), slot 10.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:148306), slot 43, text ID 41496477696 is pointed to by page (1:291224), slot 7 and by page (1:128070), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:150355), slot 15, text ID 226056470528 is pointed to by page (1:127999), slot 1 and by page (1:79561), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:163849), slot 44, text ID 208979886080 is pointed to by page (1:127996), slot 3 and by page (1:303334), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:167976), slot 42, text ID 215276191744 is pointed to by page (1:128241), slot 2 and by page (1:303316), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:173613), slot 50, text ID 190233706496 is pointed to by page (1:70653), slot 1 and by page (1:226945), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:196399), slot 67, text ID 57178390528 is pointed to by page (1:310908), slot 12 and by page (1:128396), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:202131), slot 10, text ID 58982203392 is pointed to by page (1:125063), slot 1 and by page (1:127825), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:204002), slot 87, text ID 181863710720 is pointed to by page (1:254770), slot 13 and by page (1:128399), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:212002), slot 75, text ID 204838666240 is pointed to by page (1:127398), slot 0 and by page (1:288739), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:223699), slot 1, text ID 243133972480 is pointed to by page (1:256195), slot 3 and by page (1:312159), slot 4.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:233650), slot 52, text ID 235844730880 is pointed to by page (1:310481), slot 14 and by page (1:260029), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:236621), slot 38, text ID 211040141312 is pointed to by page (1:309183), slot 7 and by page (1:128240), slot 2.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:242372), slot 87, text ID 180270596096 is pointed to by page (1:256497), slot 3 and by page (1:128064), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:253181), slot 85, text ID 227707453440 is pointed to by page (1:312868), slot 1 and by page (1:128245), slot 3.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:266611), slot 43, text ID 225814315008 is pointed to by page (1:279369), slot 10 and by page (1:308666), slot 16.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:357824), slot 81, text ID 178253660160 is pointed to by page (1:252644), slot 5 and by page (1:253835), slot 11.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:373278), slot 67, text ID 195948838912 is pointed to by page (1:127826), slot 1 and by page (1:309091), slot 7.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:413233), slot 14, text ID 206225408000 is pointed to by page (1:281667), slot 3 and by page (1:123289), slot 0.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 597577167, text, ntext, or image node page (1:457340), slot 66, text ID 246325903360 is pointed to by page (1:127996), slot 2 and by page (1:126371), slot 7.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:126554) allocated to object ID 1525580473, 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:126555) allocated to object ID 1525580473, 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:126556) allocated to object ID 1525580473, 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:126557) allocated to object ID 1525580473, 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:126558) allocated to object ID 1525580473, 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:126559) allocated to object ID 1525580473, 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:127680) allocated to object ID 1525580473, 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:127681) allocated to object ID 1525580473, 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:127682) allocated to object ID 1525580473, 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:127683) allocated to object ID 1525580473, 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:127684) allocated to object ID 1525580473, 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:127685) allocated to object ID 1525580473, 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:127686) allocated to object ID 1525580473, 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:127687) allocated to object ID 1525580473, 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:127904) allocated to object ID 1525580473, 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:127905) allocated to object ID 1525580473, 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:127906) allocated to object ID 1525580473, 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:127907) allocated to object ID 1525580473, 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:127908) allocated to object ID 1525580473, 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:127909) allocated to object ID 1525580473, 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:127910) allocated to object ID 1525580473, 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:127911) allocated to object ID 1525580473, 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:127952) allocated to object ID 1525580473, 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:127953) allocated to object ID 1525580473, 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:127954) allocated to object ID 1525580473, 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:127955) allocated to object ID 1525580473, 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:127956) allocated to object ID 1525580473, 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:127957) allocated to object ID 1525580473, 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:127958) allocated to object ID 1525580473, 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:127959) allocated to object ID 1525580473, 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:128056) allocated to object ID 1525580473, 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:128057) allocated to object ID 1525580473, 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:128058) allocated to object ID 1525580473, index ID 0 was not seen. Page may be invalid or have incorrect obj

View 5 Replies View Related

24 Consistency Errors In Database

Sep 6, 2007

Hello all,

I have a problem on SQL 2000 Server Std (inc sP4)
OS: Windows 2000 Server

What can i do for errors?

DBCC CHECKDB ('GOLD_DB, REPAIR_ALLOW_DATA_LOSS)

DBCC results for 'GOLD_DB'.
DBCC results for 'sysobjects'.
...
CHECKDB found 0 allocation errors and 24 consistency errors in database 'GOLD_DB'.
CHECKDB fixed 0 allocation errors and 24 consistency errors in database 'GOLD_DB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Greetings from istanbul, regards.

View 8 Replies View Related

How To Get Rid Of Consistency Errors Without Data

Jul 6, 2005

Vimal Kanth writes "I am using SQL Server 2000 and one of my databases has loads of consistency errors. When i try to query a particular record from a table it displays an error message similar to this

Could not find the index entry for RID '168927001232500300' in index page (1:95510), index ID 0, database 'Tristar'.

Then, i executed the DBCC CHECKDB command after going through some documentation. The results of which were something like this

Table error: Database 'Tristar', index 'DMS_VOUCHER.index_1739153241' (ID 1739153241) (index ID 2). Extra or invalid key for the keys:

Index row (1:11229:144) with values (ROWGUID = 22814645-5B2B-4B4E-A1D8-9B49DF7C8CEF`¢0; and DEALER_ID = 10121 and BRANCH_ID = 1.242260474E-307 and VOUCHER_ID = 9507) points to the data row identified by ().

Then, i executed the DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command. I lost around 3000 records when i excuted this

I dont want any data loss as this is very critical.Can you please help me overcome this problem? Thanks in advance.

Regards
Vimal Kanth"

View 20 Replies View Related

Data Consistency Errors

Apr 27, 2006

Can anyone please tell me why I recieved these errors when running dbcc check db. Thank god it was a user created "test" table in a production database and I was able to just drop the table and rerun dbcc with no errors, but this is the second time this has happened in the last month(I just started this job the week of the first error)- and we ended up having to restore to the last good backup.

Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 3, text ID 225434796032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 4, text ID 225434861568 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1543676547, index ID 255: Page (1:652193) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1543676547, index ID 255, page (1:652193). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 0, text ID 225434730496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 1, text ID 225434927104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 2, text ID 225434992640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 3, text ID 225435058176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 4, text ID 225435123712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 5, text ID 225435189248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 6, text ID 225435254784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 7, text ID 225435320320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 0, text ID 225435385856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 1, text ID 225435451392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 2, text ID 225435516928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 3, text ID 225435582464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 4, text ID 225435648000 is not referenced.
DBCC results for 'BILL_PRT_DETAIL'.
There are 909154 rows in 101409 pages for object 'BILL_PRT_DETAIL'.
DBCC results for 'BILLG_ERR_MSGS'.
There are 971 rows in 52 pages for object 'BILLG_ERR_MSGS'.
DBCC results for 'WORK_COMPCY_LEVEL'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_LEVEL'.
DBCC results for 'BILL_PRT_HEADER'.
There are 196396 rows in 24550 pages for object 'BILL_PRT_HEADER'.
DBCC results for 'WORK_COMPCY_TYPE'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_TYPE'.
DBCC results for 'BILL_PRT_MSGS'.
There are 0 rows in 0 pages for object 'BILL_PRT_MSGS'.
DBCC results for 'MTR_TMP_DTA_SEL'.
There are 0 rows in 0 pages for object 'MTR_TMP_DTA_SEL'.
DBCC results for 'WORK_IN_PROGRESS'.
There are 1 rows in 1 pages for object 'WORK_IN_PROGRESS'.
DBCC results for 'BILL_PYMT'.
There are 750053 rows in 19951 pages for object 'BILL_PYMT'.
DBCC results for 'NOTES'.
There are 26812 rows in 457 pages for object 'NOTES'.
DBCC results for 'WORK_ORDER_MASTER'.
There are 0 rows in 0 pages for object 'WORK_ORDER_MASTER'.
DBCC results for 'BUD_BILLG_AMT'.
There are 0 rows in 0 pages for object 'BUD_BILLG_AMT'.
DBCC results for 'NOTES_RELSHP'.
There are 22428 rows in 252 pages for object 'NOTES_RELSHP'.
DBCC results for 'WO_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_ACT_STAT'.
DBCC results for 'BUD_BILLG_CNSM_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_CNSM_HST'.
DBCC results for 'NXT_NBR'.
There are 7 rows in 1 pages for object 'NXT_NBR'.
DBCC results for 'WO_ADDTNL_INFO'.
There are 0 rows in 0 pages for object 'WO_ADDTNL_INFO'.
DBCC results for 'BUD_BILLG_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_HST'.
DBCC results for 'PARENT_HST'.
There are 0 rows in 0 pages for object 'PARENT_HST'.
DBCC results for 'WO_APPVL_ROUTING'.
There are 0 rows in 0 pages for object 'WO_APPVL_ROUTING'.
DBCC results for 'BUD_BILLG_WTHR_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_HST'.
DBCC results for 'PHY_ADDR'.
There are 70776 rows in 7905 pages for object 'PHY_ADDR'.
DBCC results for 'WO_BEHAVIOR_RULE'.
There are 0 rows in 0 pages for object 'WO_BEHAVIOR_RULE'.
DBCC results for 'BUD_BILLG_WTHR_SEV'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_SEV'.
DBCC results for 'POSTAL_TOWN_CD'.
There are 29539 rows in 569 pages for object 'POSTAL_TOWN_CD'.
DBCC results for 'WO_COMPONENTS'.
There are 0 rows in 0 pages for object 'WO_COMPONENTS'.
DBCC results for 'BUS_UNT'.
There are 1310 rows in 25 pages for object 'BUS_UNT'.
DBCC results for 'cash match'.
There are 738871 rows in 6720 pages for object 'cash match'.
DBCC results for 'POSTED_HISTORY'.
There are 1230436 rows in 26768 pages for object 'POSTED_HISTORY'.
DBCC results for 'WO_CONSTANTS'.
There are 0 rows in 0 pages for object 'WO_CONSTANTS'.
DBCC results for 'BUS_UNT_MSTR'.
There are 0 rows in 0 pages for object 'BUS_UNT_MSTR'.
DBCC results for 'Cashmatch7_30'.
There are 727509 rows in 6619 pages for object 'Cashmatch7_30'.
DBCC results for 'PROFILE_CAT'.
There are 0 rows in 0 pages for object 'PROFILE_CAT'.
DBCC results for 'WO_EDIT_RULE'.
There are 0 rows in 0 pages for object 'WO_EDIT_RULE'.
DBCC results for 'CNSMPTN_SVC_CONTN'.
There are 36776 rows in 928 pages for object 'CNSMPTN_SVC_CONTN'.
DBCC results for 'Trace_cash_match'.
There are 815011 rows in 7412 pages for object 'Trace_cash_match'.
DBCC results for 'PROOF_BILL_PRT_DTL'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_DTL'.
DBCC results for 'WO_MASTER_FILE'.
There are 0 rows in 0 pages for object 'WO_MASTER_FILE'.
DBCC results for 'cash match 8-24'.
There are 815011 rows in 7414 pages for object 'cash match 8-24'.
CHECKDB found 0 allocation errors and 17 consistency errors in table 'cash match 8-24' (object ID 1543676547).
DBCC results for 'PROOF_BILL_PRT_HDR'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_HDR'.
DBCC results for 'CNVRGT_BILLG_DTL'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_DTL'.
DBCC results for 'WO_RTG_APPVL_MSTR'.
There are 0 rows in 0 pages for object 'WO_RTG_APPVL_MSTR'.
DBCC results for 'PYMT_TERMS'.
There are 2 rows in 1 pages for object 'PYMT_TERMS'.
DBCC results for 'CNVRGT_BILLG_HDR'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_HDR'.
DBCC results for 'WO_STAT'.
There are 0 rows in 0 pages for object 'WO_STAT'.
DBCC results for 'Cash Matching Process'.
There are 836838 rows in 7612 pages for object 'Cash Matching Process'.
DBCC results for 'RD_CYCLE'.
There are 55 rows in 1 pages for object 'RD_CYCLE'.
DBCC results for 'WO_STAT_RULES'.
There are 0 rows in 0 pages for object 'WO_STAT_RULES'.
DBCC results for 'REASON_CD'.
There are 0 rows in 0 pages for object 'REASON_CD'.
DBCC results for 'WO_TYP'.
There are 0 rows in 0 pages for object 'WO_TYP'.
DBCC results for 'COLCT_RULES'.
There are 30 rows in 1 pages for object 'COLCT_RULES'.
DBCC results for 'RECEIPTS_BTCH'.
There are 2109 rows in 44 pages for object 'RECEIPTS_BTCH'.
DBCC results for 'nightly107'.
There are 344086 rows in 3225 pages for object 'nightly107'.
DBCC results for 'WO_TYP_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_TYP_ACT_STAT'.
DBCC results for 'COMPONENT_MASTER'.
There are 0 rows in 0 pages for object 'COMPONENT_MASTER'.
DBCC results for 'RECEIPTS_I_FILE'.
There are 51698 rows in 3244 pages for object 'RECEIPTS_I_FILE'.
DBCC results for 'NightCash10-12'.
There are 64657 rows in 592 pages for object 'NightCash10-12'.
DBCC results for 'WRK_CENTER_WRK_SCH'.
There are 0 rows in 0 pages for object 'WRK_CENTER_WRK_SCH'.
DBCC results for 'CONS_SVC_CONN_CD'.
There are 1524 rows in 20 pages for object 'CONS_SVC_CONN_CD'.
DBCC results for 'RECEIPT_ITM'.
There are 151581 rows in 6334 pages for object 'RECEIPT_ITM'.
DBCC results for 'Utiligy Cash Match Trace'.
There are 321627 rows in 2928 pages for object 'Utiligy Cash Match Trace'.
DBCC results for 'WRTOFF_GL_CLASS_CD'.
There are 0 rows in 0 pages for object 'WRTOFF_GL_CLASS_CD'.
DBCC results for 'CONTACT_INFO'.
There are 1 rows in 1 pages for object 'CONTACT_INFO'.
DBCC results for 'REFUND_HISTORY'.
There are 906 rows in 24 pages for object 'REFUND_HISTORY'.
DBCC results for 'RECEIPTS_I_FILE2'.
There are 48343 rows in 3022 pages for object 'RECEIPTS_I_FILE2'.
DBCC results for 'CUST_ADDR_REL'.
There are 70611 rows in 2258 pages for object 'CUST_ADDR_REL'.
DBCC results for 'REPORT_TYPE'.
There are 42 rows in 1 pages for object 'REPORT_TYPE'.
DBCC results for 'CUST_CNTRCT_RELSHP'.
There are 0 rows in 0 pages for object 'CUST_CNTRCT_RELSHP'.
DBCC results for 'REQ_READ_SCH'.
There are 1 rows in 1 pages for object 'REQ_READ_SCH'.
DBCC results for 'RESOURCE_ASGNDS'.
There are 0 rows in 0 pages for object 'RESOURCE_ASGNDS'.
DBCC results for 'CUST_INFO'.
There are 36779 rows in 2480 pages for object 'CUST_INFO'.
DBCC results for 'RESOURCE_MASTER'.
There are 0 rows in 0 pages for object 'RESOURCE_MASTER'.
DBCC results for 'RESOURCE_WORK_SCH'.
There are 0 rows in 0 pages for object 'RESOURCE_WORK_SCH'.
DBCC results for 'CUST_PYMT_ACCT'.
There are 0 rows in 0 pages for object 'CUST_PYMT_ACCT'.
DBCC results for 'ROUTE'.
There are 95 rows in 2 pages for object 'ROUTE'.
DBCC results for 'ADDR'.
There are 70767 rows in 861 pages for object 'ADDR'.
DBCC results for 'CUST_STMT_HST'.
There are 0 rows in 0 pages for object 'CUST_STMT_HST'.
DBCC results for 'ROUTE_RD_CYCLE'.
There are 0 rows in 0 pages for object 'ROUTE_RD_CYCLE'.
DBCC results for 'AGING_DAYS_TBL'.
There are 5 rows in 1 pages for object 'AGING_DAYS_TBL'.
DBCC results for 'CUST_SVC_RELSHP'.
There are 73551 rows in 1415 pages for object 'CUST_SVC_RELSHP'.
DBCC results for 'RPT_TYPE_CRITERIA'.
There are 116 rows in 2 pages for object 'RPT_TYPE_CRITERIA'.
DBCC results for 'AMX_MSG_LG'.
There are 0 rows in 0 pages for object 'AMX_MSG_LG'.
DBCC results for 'RPT_VERSION'.
There are 32 rows in 1 pages for object 'RPT_VERSION'.
DBCC results for 'DED_MTR_CONSUM'.
There are 0 rows in 0 pages for object 'DED_MTR_CONSUM'.
DBCC results for 'ASGND_BILL_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_BILL_CAT_CD'.
DBCC results for 'RPT_VRSN_CRITERIA'.
There are 15 rows in 1 pages for object 'RPT_VRSN_CRITERIA'.
DBCC results for 'DED_MTR_POS'.
There are 0 rows in 0 pages for object 'DED_MTR_POS'.
DBCC results for 'ASGND_CUST_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_CUST_CAT_CD'.
DBCC results for 'SCH_POOL'.
There are 0 rows in 0 pages for object 'SCH_POOL'.
DBCC results for 'DED_MTR_RDING_HIST'.
There are 0 rows in 0 pages for object 'DED_MTR_RDING_HIST'.
CHECKDB found 0 allocation errors and 17 consistency errors in database 'UtiligyPD'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (UtiligyPD ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Thanks!
Anita

View 5 Replies View Related

Data Consistency Issue

Jan 15, 2007

Hello Experts,

Posted initial issue under following ID.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=77603

Here is output produced by DBCC CHECKDB

Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:8) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:9) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:10) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:11) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:12) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:13) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:14) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:15) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:16) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:38) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:39) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:40) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:41) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:42) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:43) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:44) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:0) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:1) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:2) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:7) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:8) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:9) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:10) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:11) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:12) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:0) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:1) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:2) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:3) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:4) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:5) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:0) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:1) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:0) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:1) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:2) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:3) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:4) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:5) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:6) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:7) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:0) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:1) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:2) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:3) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:4) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:5) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:6) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:7) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:8) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-I' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:3) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:4) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:5) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:6) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-D' and ? = NULL) points to the data row identified by ().
DBCC results for 'dbS_CoreData'.
DBCC results for 'sysobjects'.
There are 341 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 610 rows in 42 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 2035 rows in 41 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 348 rows in 94 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 16 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 5 rows in 2 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2690 rows in 15 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 22 rows in 1 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 'tmp_KCE_Eval_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Eval_Round'.
DBCC results for 'tmp_KCE_Eval_Property'.
There are 20 rows in 1 pages for object 'tmp_KCE_Eval_Property'.
DBCC results for 'tmp_KCE_Eval_Task'.
There are 33 rows in 2 pages for object 'tmp_KCE_Eval_Task'.
DBCC results for 'tmp_KCE_Eval_Note'.
There are 113 rows in 3 pages for object 'tmp_KCE_Eval_Note'.
DBCC results for 'tmp_KCE_Train_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Train_Round'.
DBCC results for 'tmp_KCE_Train_Property'.
There are 30 rows in 1 pages for object 'tmp_KCE_Train_Property'.
DBCC results for 'tmp_KCE_Train_Task'.
There are 38 rows in 2 pages for object 'tmp_KCE_Train_Task'.
DBCC results for 'dlg_TeamCodes'.
There are 34 rows in 1 pages for object 'dlg_TeamCodes'.
DBCC results for 'cur_Round'.
There are 894 rows in 39 pages for object 'cur_Round'.
DBCC results for 'tmp_KCE_Train_Note'.
There are 160 rows in 4 pages for object 'tmp_KCE_Train_Note'.
DBCC results for 'dlg_Users'.
There are 397 rows in 16 pages for object 'dlg_Users'.
DBCC results for 'cur_Property'.
There are 92033 rows in 6880 pages for object 'cur_Property'.
DBCC results for 'cur_Task'.
There are 125253 rows in 9057 pages for object 'cur_Task'.
DBCC results for 'cur_Note'.
There are 339746 rows in 14089 pages for object 'cur_Note'.
CHECKDB found 0 allocation errors and 54 consistency errors in table 'cur_Note' (object ID 246291937).
DBCC results for 'arc_Note'.
There are 15609480 rows in 310776 pages for object 'arc_Note'.
DBCC results for 'arc_FieldNote'.
There are 1633726 rows in 41597 pages for object 'arc_FieldNote'.
DBCC results for 'dlg_UserTasks'.
There are 3116 rows in 39 pages for object 'dlg_UserTasks'.
DBCC results for 'dlg_ImportDetails'.
There are 1958 rows in 36 pages for object 'dlg_ImportDetails'.
DBCC results for 'arc_Property'.
There are 3729453 rows in 128092 pages for object 'arc_Property'.
DBCC results for 'arc_Round'.
There are 99219 rows in 2010 pages for object 'arc_Round'.
DBCC results for 'arc_Task'.
There are 5445171 rows in 185259 pages for object 'arc_Task'.
DBCC results for 'cur_FieldNote'.
There are 5647 rows in 242 pages for object 'cur_FieldNote'.
DBCC results for 'dlg_tmpAddZone'.
There are 0 rows in 15 pages for object 'dlg_tmpAddZone'.
DBCC results for 'dlg_Clients'.
There are 30 rows in 1 pages for object 'dlg_Clients'.
DBCC results for 'GenesisCheckReads'.
There are 13932 rows in 277 pages for object 'GenesisCheckReads'.
DBCC results for 'tmp_Duplicate_Tasks'.
There are 3947 rows in 127 pages for object 'tmp_Duplicate_Tasks'.
DBCC results for 'log_RoundActivity'.
There are 429434 rows in 5074 pages for object 'log_RoundActivity'.
DBCC results for 'copy_cur_Task'.
There are 138705 rows in 4439 pages for object 'copy_cur_Task'.
DBCC results for 'RoundTable'.
There are 5419 rows in 43 pages for object 'RoundTable'.
DBCC results for 'dlg_TaskTypes'.
There are 15 rows in 1 pages for object 'dlg_TaskTypes'.
DBCC results for 'log_Activity'.
There are 458463 rows in 9322 pages for object 'log_Activity'.
DBCC results for 'lib_RoundPerformance'.
There are 99387 rows in 2601 pages for object 'lib_RoundPerformance'.
DBCC results for 'dlg_SysUtilsRoundsRef'.
There are 1 rows in 1 pages for object 'dlg_SysUtilsRoundsRef'.
DBCC results for 'khutemp'.
There are 19747 rows in 470 pages for object 'khutemp'.
DBCC results for 'tmp_TempICPs'.
There are 14 rows in 1 pages for object 'tmp_TempICPs'.
DBCC results for 'dlg_Holidays'.
There are 53 rows in 1 pages for object 'dlg_Holidays'.
DBCC results for 'log_Comms'.
There are 2168949 rows in 73621 pages for object 'log_Comms'.
DBCC results for 'dlg_RefRound'.
There are 196 rows in 1 pages for object 'dlg_RefRound'.
DBCC results for 'Temp_RFICP'.
There are 38 rows in 1 pages for object 'Temp_RFICP'.
DBCC results for 'dlg_AreaCodes'.
There are 62 rows in 1 pages for object 'dlg_AreaCodes'.
DBCC results for 'dlg_GroupDetails'.
There are 350 rows in 5 pages for object 'dlg_GroupDetails'.
DBCC results for 'dlg_Countries'.
There are 3 rows in 1 pages for object 'dlg_Countries'.
DBCC results for 'dlg_Groups'.
There are 18 rows in 1 pages for object 'dlg_Groups'.
DBCC results for 'dlg_DumpResultImport'.
There are 0 rows in 0 pages for object 'dlg_DumpResultImport'.
DBCC results for 'dlg_Companies'.
There are 4 rows in 1 pages for object 'dlg_Companies'.
DBCC results for 'dlg_UserDetails'.
There are 188 rows in 3 pages for object 'dlg_UserDetails'.
DBCC results for 'tmp_EOLUnreadICPs'.
There are 28 rows in 1 pages for object 'tmp_EOLUnreadICPs'.
DBCC results for 'log_Importfiles'.
There are 2022 rows in 145 pages for object 'log_Importfiles'.
DBCC results for 'dlg_UserSecurity'.
There are 188 rows in 2 pages for object 'dlg_UserSecurity'.
DBCC results for 'log_LoginSession'.
There are 2049029 rows in 35632 pages for object 'log_LoginSession'.
DBCC results for 'dlg_DeviceDetails'.
There are 197 rows in 7 pages for object 'dlg_DeviceDetails'.
DBCC results for 'cur_FieldResult'.
There are 23907 rows in 899 pages for object 'cur_FieldResult'.
DBCC results for 'arc_FieldResult'.
There are 5539213 rows in 168533 pages for object 'arc_FieldResult'.
DBCC results for 'dlg_DialogServerLog'.
There are 1442 rows in 33 pages for object 'dlg_DialogServerLog'.
DBCC results for 'dlg_UserZones'.
There are 6484 rows in 56 pages for object 'dlg_UserZones'.
DBCC results for 'log_RPT_Selection_Crieteria'.
There are 64529 rows in 21127 pages for object 'log_RPT_Selection_Crieteria'.
DBCC results for 'log_Communication_Detail'.
There are 8175148 rows in 87720 pages for object 'log_Communication_Detail'.
DBCC results for 'dlg_ZoneCodes'.
There are 2268 rows in 28 pages for object 'dlg_ZoneCodes'.
DBCC results for 'DRQA01MRP'.
There are 83 rows in 2 pages for object 'DRQA01MRP'.
DBCC results for 'tmp_abc'.
There are 3 rows in 1 pages for object 'tmp_abc'.
DBCC results for 'dlg_DumpNoteImport'.
There are 14 rows in 1 pages for object 'dlg_DumpNoteImport'.
DBCC results for 'dlg_FilePaths'.
There are 1 rows in 1 pages for object 'dlg_FilePaths'.
DBCC results for 'dlg_MRPErrors'.
There are 296 rows in 12 pages for object 'dlg_MRPErrors'.
DBCC results for 'rpt_SubHeaderInfo'.
There are 46 rows in 3 pages for object 'rpt_SubHeaderInfo'.
DBCC results for 'dlg_SystemUtilities'.
There are 7 rows in 1 pages for object 'dlg_SystemUtilities'.
DBCC results for 'dlg_ErrorLog'.
There are 1401 rows in 49 pages for object 'dlg_ErrorLog'.
DBCC results for 'dlg_ExportDetails'.
There are 69883 rows in 4581 pages for object 'dlg_ExportDetails'.
DBCC results for 'dtproperties'.
There are 28 rows in 1 pages for object 'dtproperties'.
DBCC results for 'dlg_Tasks'.
There are 72 rows in 1 pages for object 'dlg_Tasks'.
DBCC results for 'log_RoundPerform'.
There are 0 rows in 0 pages for object 'log_RoundPerform'.
DBCC results for 'rpt_HeaderInfo'.
There are 4 rows in 1 pages for object 'rpt_HeaderInfo'.
DBCC results for 'dlg_Supervisors'.
There are 1613 rows in 13 pages for object 'dlg_Supervisors'.
CHECKDB found 0 allocation errors and 54 consistency errors in database 'dbS_CoreData'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (dbS_CoreData ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

*PLease LET ME KNOW WHAT IS RECOMMENED FURTHER STEP IN ORDER TO ELIMINATE THIS ERROR PERMANENTLY.. THANKS IN ADVANCE.
I am using SQL 2000 WITH sp4.

SKR

View 3 Replies View Related

AdventureWorks Database - Cannot Access Database Diagrams

Feb 20, 2007

Hi,

When I try to access the database diagrams in AdventureWorks, I get the following message:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

------------------------------
BUTTONS:

OK
------------------------------

Why is this?

All advice / help apprecuated.

Thanks

View 1 Replies View Related

Cannot Install Database Diagrams On AdventureWorks Database

Jun 11, 2007

Error Message: Database diagram support objects cannot be installed because this database does not have a valid owner.

How do I create a valid owner for the database?

View 4 Replies View Related

Getting Table Names From AdventureWorks Database

Apr 24, 2008

Hello,
I have ran into a problem when i'm getting table names in c#.
I have tried the sql command:
select name from sysobjects where type='U' order by name
So it returns the names without a problem. But when I try to access to some tables using their names (to retrieve the columns) I sometimes get the error "Invalid object name" following by the name of the table.
So I realized the if the table was not under dbo user then i would get this error.
for example: "select name from ContactCreditCard"
gives me error because in database management tool it is shown like this: Sales.ContactCreditCard
How can i fix this problem? How to get that prefix of the tables?

Thank you,

View 8 Replies View Related

Can't Deploy AdventureWorks AS Database Using Instances Of SQL And AS

Jul 26, 2005

Hi all,

View 20 Replies View Related

SQL 2012 :: Database Consistency Report

Apr 4, 2014

I ran the database consistency on 2 databases, the first little used (and relatively new), the other much more active. On the little used db the report didn't return any lines. On the much more active DB it returned 6 lines (one each for the last 6 days). They all reported 0 errors. Should I be concerned that the one database is actually reporting information, even if it appears to tell me "all clear"?

View 8 Replies View Related

Problems Reading Data From Adventureworks

Jul 21, 2006

hi there,

I installed the Adventureworks sample database and can see it from the server managment studio express. I am doing now an tutorial from Microsoft to display the data in a grid view using Visual Web Developer 2005 Express.

I am connecting to the DB with this connection string: "Data Source=STK-SASA-MX025SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" and I can see all the tables of the database. When I try to select some fields from the database using the wizard, like: SELECT [Name] FROM [ProductCategory] I get the following error message:

Invalid object name: ProductCategory, and to check the syntax and the types, but it seems to me quite standard SQL.

Anybody could help me please?

Thanks

Theo

View 3 Replies View Related

Data Read-Consistency During Update

Sep 27, 2007

Hi folks,I have 3 tables of related data in SQL 2000/2005 that receive periodic adds/updates every 30 seconds.I have enabled transactions on all updates, is anything else needed to ensure data consistency during reads in a high # of fetches per second situation?Thanks,johnEdit:Clarification -- I just need the data to be correctly displayed to all users.

View 2 Replies View Related

Data Format Consistency Or Query?

Oct 2, 2006

Hi

I have a table that stores the period and year as two seperate fields the problem that i have is that when the data is entered in the data base the period is sometime entered as 6 or 06, hence i have a table thaat looks like as follows:

Period Year
====== ====
6 2006
06 2005
12 2006
3 2005
2 2005
4 2005
04 2005
03 2005

when i currently query the information using the period i use the LIKE command in SQL which gives me the results but the problem is when the like is done with 2 as the period value it also retrieves the 12, 02, and 2, in that case the period 12 was not that was requested.

I was wondering is there a way to reformat the data so that all the data is in a consistent format?

Or is there a better way of quering the information in the current format?

View 13 Replies View Related

Save A Copy Of Modified Adventureworks Database

Apr 21, 2008

Hi
I have been working with advantureworks database and make some modifications on it.
I need to be able to have a copy of this modified adventureworks database and use it on my laptop.
How can I do this if it is possible.
What I need to do is to be able to save everything I have been working on with the adventureworks on my desktop and be able to save on my laptop and proceed without lossing information. I want to install trial version of sql server 2005 on my laptop and replace the advantureworks which came with it with the modified advantureworks I have been working on.
I am travelling this week and I would like to continue what I have been working on using my laptop. I appreciate much your quick response

Thanks

View 3 Replies View Related

MS SQL Server 2005 -- Cant Not Attach To AdventureWorks Database

Jun 8, 2007

I have MS SQL Server 2005 installed and when trying to connect to AdventureWorks DB

Downloaded AdventureWorksDB.msi file and when trying to attach recieve this error when running script ?

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Then tried to attach the DB and get this

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'JKIMBLE1'. (Microsoft.SqlServer.Smo)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Is there a difference between MS SQL Server 2005 and SQL Server 2005 Express Edition

View 6 Replies View Related

AdventureWorks Sample Database &&amp; Data Consistency

AdventureWorks Sample Database && Data Consistency