------=_NextPart_000_01BC6D98.1F5768D0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Attached are the results.
>
> try a:
>
> DBCC CheckDB(Emerald)
>
> on the Emerald database from isql_w. You could have an identity problem
> in the database.
>
------=_NextPart_000_01BC6D98.1F5768D0
Content-Type: application/octet-stream; name="Results.RPT"
Content-Transfer-Encoding: quoted-printable
Content-Description: Results.RPT ()
Content-Disposition: attachment; filename="Results.RPT"
Checking Emerald
Checking 1
The total number of data pages in this table is 22.
Table has 315 data rows.
Checking 2
The total number of data pages in this table is 11.
Table has 112 data rows.
Checking 3
The total number of data pages in this table is 24.
Table has 588 data rows.
Checking 4
The total number of data pages in this table is 1.
Table has 26 data rows.
Checking 5
The total number of data pages in this table is 140.
Table has 641 data rows.
Checking 6
The total number of data pages in this table is 6.
Table has 145 data rows.
Checking 7
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 8
The total number of data pages in this table is 425.
The number of data pages in Sysindexes for this table was 974. It has =
been corrected to 425.
The number of rows in Sysindexes for this table was 26545. It has been =
corrected to 11481.
*** NOTICE: Notification of log space used/free cannot be reported =
because the log segment is not on its own device.
Table has 11481 data rows.
Checking 9
The total number of data pages in this table is 11.
The number of data pages in Sysindexes for this table was 10. It has =
been corrected to 11.
Table has 628 data rows.
Checking 10
The total number of data pages in this table is 1.
Table has 11 data rows.
Checking 11
The total number of data pages in this table is 1.
Checking 12
The total number of data pages in this table is 1.
Table has 20 data rows.
Checking 13
The total number of data pages in this table is 1.
Checking 14
The total number of data pages in this table is 3.
Table has 55 data rows.
Checking 15
The total number of data pages in this table is 5.
Table has 235 data rows.
Checking 16
The total number of data pages in this table is 1.
Checking 17
The total number of data pages in this table is 1.
Checking 18
The total number of data pages in this table is 1.
Checking 21575115
The total number of data pages in this table is 1.
Checking 53575229
The total number of data pages in this table is 3.
Table has 48 data rows.
Checking 85575343
The total number of data pages in this table is 1.
Table has 16 data rows.
Checking 117575457
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 149575571
The total number of data pages in this table is 1.
Checking 181575685
The total number of data pages in this table is 1.
Table has 4 data rows.
Checking 213575799
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 245575913
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking 277576027
The total number of data pages in this table is 1.
Checking 309576141
The total number of data pages in this table is 1.
Table has 9 data rows.
Checking 341576255
The total number of data pages in this table is 1.
Table has 5 data rows.
Checking 373576369
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 405576483
The total number of data pages in this table is 1.
Checking 437576597
The total number of data pages in this table is 1.
Checking 469576711
The total number of data pages in this table is 29.
The total number of TEXT/IMAGE pages in this table is 202.
Table has 202 data rows.
Checking 501576825
The total number of data pages in this table is 1.
Table has 20 data rows.
Checking 533576939
The total number of data pages in this table is 3.
Table has 82 data rows.
Checking 565577053
The total number of data pages in this table is 1.
Checking 597577167
The total number of data pages in this table is 1.
Checking 629577281
The total number of data pages in this table is 10.
Table has 172 data rows.
Checking 661577395
The total number of data pages in this table is 1.
Checking 693577509
The total number of data pages in this table is 4.
Table has 149 data rows.
Checking 725577623
The total number of data pages in this table is 17.
Table has 175 data rows.
Checking 757577737
The total number of data pages in this table is 1.
Checking 789577851
The total number of data pages in this table is 1.
Checking 821577965
The total number of data pages in this table is 1.
Checking 853578079
The total number of data pages in this table is 1.
Checking 885578193
The total number of data pages in this table is 1.
The total number of TEXT/IMAGE pages in this table is 12.
Table has 12 data rows.
Checking 917578307
The total number of data pages in this table is 10.
Table has 242 data rows.
Checking 949578421
The total number of data pages in this table is 1.
Checking 981578535
The total number of data pages in this table is 1.
Checking 1013578649
The total number of data pages in this table is 1.
Checking 1045578763
The total number of data pages in this table is 1.
Checking 1401056027
The total number of data pages in this table is 9503.
Table has 111661 data rows.
Checking 1433056141
The total number of data pages in this table is 1.
Table has 12 data rows.
Checking 1465056255
The total number of data pages in this table is 1.
Checking 1497056369
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 1529056483
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 1561056597
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 1593056711
The total number of data pages in this table is 1.
Checking 1625056825
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 1657056939
The total number of data pages in this table is 1.
Checking 1689057053
The total number of data pages in this table is 1.
Table has 13 data rows.
Checking 1721057167
The total number of data pages in this table is 1.
Table has 4 data rows.
Checking 1753057281
The total number of data pages in this table is 3.
Table has 118 data rows.
Checking 1785057395
The total number of data pages in this table is 1.
Checking 1817057509
The total number of data pages in this table is 1.
Checking 1849057623
The total number of data pages in this table is 1.
Checking 1881057737
The total number of data pages in this table is 1.
Table has 5 data rows.
Checking 1913057851
The total number of data pages in this table is 1.
Table has 10 data rows.
Checking 1945057965
The total number of data pages in this table is 1.
The total number of TEXT/IMAGE pages in this table is 1.
Table has 1 data rows.
Checking 1977058079
The total number of data pages in this table is 1.
The total number of TEXT/IMAGE pages in this table is 3.
Table has 3 data rows.
Checking 2009058193
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 2041058307
The total number of data pages in this table is 1.
Checking 2073058421
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 2105058535
The total number of data pages in this table is 1.
Checking 2137058649
The total number of data pages in this table is 2.
Table has 127 data rows.
DBCC execution completed. If DBCC printed error messages, see your =
System Administrator.
------=_NextPart_000_01BC6D98.1F5768D0--