Index Corruption On Table Without Key: What Could Be The Reasons ?

Sep 14, 2005

Dear group,

we are running a SQL-Server Database which is about 30 GB large. The
purpose of this database is to contain periodic data from automatic
devices which insert values into some tables.

Unfortunately most of these tables don't have a key (and a key can only
be introduced when the application programmers have changed their
software). Tables have this structure

deviceno timestamp data

where we expect for every device and timestamp one row of data.

In the ongoing operation it happens that the index of this large table
gets corrupted and a select from this table yields 2 rows for some
devices.

In fact a select "SELECT DEVICENO, TIMESTAMP, COUNT(*) FROM TABLE GROUP
BY DEVICENO, TIMESTAMP HAVING COUNT(*) > 1" returns lots of data.

After rebuild of the indexes the table is "clean" again.

What could cause the index corruption ?

Missing key?
Faulty application program ?
a combination of both ?

How can i prevent this from happening again, as long as there is no
updated database / application ?

I'd be grateful for any useful comment

Regards

Uli

View 14 Replies

Index Corruption

Jan 8, 2001

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

View 1 Replies View Related

Index Corruption Help

May 18, 2001

I started seeing the following error in our 6.5 error log:
-----------------------------------------------------------------
Retrying row fetch: rid(3) > pnextrno(3) (pg 0x23b1b6, obj 0x337fafdd, db 6, stat 100c/1)

Getrow: rid(3) > pnextrno(3) (pg 0x23b1b6, obj 0x337fafdd, db 6, stat 100c/1)

Error : 624, Severity: 20, State: 1
Attempt to retrieve row from page via RID failed because the requested RID has a higher number than the last RID on the page. Rid pageid is 0x3 and row num is 0xffffee20.Page pointer = 0x14104800, pageno = 2339254, status = 0x111, objectid = 864006109, indexid = 0.
------------------------------------------------------------------
I ran dbcc checkdb to locate the problem and found that a non clustered index on one of the tables was corrupt so I recreated the index and no error show up when I run dbcc checkdb.

But the error message still shows up at least once a day. I ran dbcc newalloc and found an allocation discrepency and looking into this right now. Is there anything I can do to speed up my search process to find the exact cause of this problem? I need all the help I can get. Thanks.

View 1 Replies View Related

Index Corruption

Jun 27, 2005

We found the following error 4 times in our SQL Server 2000 Service Pack 4 (SP4) log:

Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '163030314f564d30353034200' in index page (1:40729731), index ID 0, database 'MyDB'..

The last time it happened in the middle of the delete process, previous time during the reading process.
We run checkDB and result is 162 consistency errors in database 'MyDB'. The errors are like that:

Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 1141579105, Index ID 0. Keys out of order on page (1:40729731), slots 14 and 15.
Server: Msg 2512, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 0. Duplicate keys on page (1:40729731) slot 28 and page (1:40729731) slot 29.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 2. Keys out of order on page (1:41115503), slots 428 and 429.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1141579105, Index ID 2. Keys out of order on page (1:41117738), slots 131 and 132.

What we have to do? Will rebuilding indexes help or we have to do some additional steps? Can Dbcc dbrecover help?
What may be the reason for the problem?

Thank you for your help,
a_k_

View 16 Replies View Related

Index Corruption

Jun 27, 2005

View 1 Replies View Related

What Might Cause Index Corruption?

Mar 24, 2006

Hi, I have experience an Index corruption on one table. I'd like to know the root cause so that I can provent it. Here is some information about the table.

1)This records of the table may be frequently Deleted/Inserted/Updated via stored procedures, one record at a time (no bulk operations).

2)I noticed there are unnecessary index on this table. I suspect the cluster Index of ScriptID, non uncluser Index (ProjectID, ScriptID), non-cluster Index (ProjectID) caused the problem.

3)Will this be hardware related?

The following is the output of DBCC CheckTable

Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:0) identified by (RID = (1:2694:0) ScriptID = 2178) has index values (ProjectID = 1 and ScriptID = 2178 and ScriptID = 2178).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:1) identified by (RID = (1:2694:1) ScriptID = 2179) has index values (ProjectID = 1 and ScriptID = 2179 and ScriptID = 2179).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:2) identified by (RID = (1:2694:2) ScriptID = 2180) has index values (ProjectID = 1 and ScriptID = 2180 and ScriptID = 2180).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:3) identified by (RID = (1:2694:3) ScriptID = 2181) has index values (ProjectID = 1 and ScriptID = 2181 and ScriptID = 2181).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:4) identified by (RID = (1:2694:4) ScriptID = 2182) has index values (ProjectID = 1 and ScriptID = 2182 and ScriptID = 2182).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:5) identified by (RID = (1:2694:5) ScriptID = 2183) has index values (ProjectID = 1 and ScriptID = 2183 and ScriptID = 2183).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
DBCC results for 'tblScript'.
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:6) identified by (RID = (1:2694:6) ScriptID = 2184) has index values (ProjectID = 1 and ScriptID = 2184 and ScriptID = 2184).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:7) identified by (RID = (1:2694:7) ScriptID = 2185) has index values (ProjectID = 1 and ScriptID = 2185 and ScriptID = 2185).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:8) identified by (RID = (1:2694:8) ScriptID = 2186) has index values (ProjectID = 1 and ScriptID = 2186 and ScriptID = 2186).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:9) identified by (RID = (1:2694:9) ScriptID = 2187) has index values (ProjectID = 1 and ScriptID = 2187 and ScriptID = 2187).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:10) identified by (RID = (1:2694:10) ScriptID = 2188) has index values (ProjectID = 1 and ScriptID = 2188 and ScriptID = 2188).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:11) identified by (RID = (1:2694:11) ScriptID = 2189) has index values (ProjectID = 1 and ScriptID = 2189 and ScriptID = 2189).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:12) identified by (RID = (1:2694:12) ScriptID = 2190) has index values (ProjectID = 1 and ScriptID = 2190 and ScriptID = 2190).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:13) identified by (RID = (1:2694:13) ScriptID = 2191) has index values (ProjectID = 1 and ScriptID = 2191 and ScriptID = 2191).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:14) identified by (RID = (1:2694:14) ScriptID = 2192) has index values (ProjectID = 1 and ScriptID = 2192 and ScriptID = 2192).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:15) identified by (RID = (1:2694:15) ScriptID = 2193) has index values (ProjectID = 1 and ScriptID = 2193 and ScriptID = 2193).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:16) identified by (RID = (1:2694:16) ScriptID = 2194) has index values (ProjectID = 1 and ScriptID = 2194 and ScriptID = 2194).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:17) identified by (RID = (1:2694:17) ScriptID = 2195) has index values (ProjectID = 1 and ScriptID = 2195 and ScriptID = 2195).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:18) identified by (RID = (1:2694:18) ScriptID = 2196) has index values (ProjectID = 1 and ScriptID = 2196 and ScriptID = 2196).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:19) identified by (RID = (1:2694:19) ScriptID = 2197) has index values (ProjectID = 1 and ScriptID = 2197 and ScriptID = 2197).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:20) identified by (RID = (1:2694:20) ScriptID = 2198) has index values (ProjectID = 1 and ScriptID = 2198 and ScriptID = 2198).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:21) identified by (RID = (1:2694:21) ScriptID = 2199) has index values (ProjectID = 1 and ScriptID = 2199 and ScriptID = 2199).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:22) identified by (RID = (1:2694:22) ScriptID = 2200) has index values (ProjectID = 1 and ScriptID = 2200 and ScriptID = 2200).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:23) identified by (RID = (1:2694:23) ScriptID = 2204) has index values (ProjectID = 1 and ScriptID = 2204 and ScriptID = 2204).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:24) identified by (RID = (1:2694:24) ScriptID = 2205) has index values (ProjectID = 1 and ScriptID = 2205 and ScriptID = 2205).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:25) identified by (RID = (1:2694:25) ScriptID = 2207) has index values (ProjectID = 1 and ScriptID = 2207 and ScriptID = 2207).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:26) identified by (RID = (1:2694:26) ScriptID = 2209) has index values (ProjectID = 1 and ScriptID = 2209 and ScriptID = 2209).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:27) identified by (RID = (1:2694:27) ScriptID = 2210) has index values (ProjectID = 1 and ScriptID = 2210 and ScriptID = 2210).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:28) identified by (RID = (1:2694:28) ScriptID = 2211) has index values (ProjectID = 1 and ScriptID = 2211 and ScriptID = 2211).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'IX_tblScript' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:29) identified by (RID = (1:2694:29) ScriptID = 2212) has index values (ProjectID = 1 and ScriptID = 2212 and ScriptID = 2212).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.IX_tblScript' (ID 848774131) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3608:105) with values (ProjectID = 1 and ScriptID = 2170 and ScriptID = 2170) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.IX_tblScript' (ID 848774131) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3608:106) with values (ProjectID = 1 and ScriptID = 2171 and ScriptID = 2171) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.IX_tblScript' (ID 848774131) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3608:107) with values (ProjectID = 1 and ScriptID = 2173 and ScriptID = 2173) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.IX_tblScript' (ID 848774131) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3608:108) with values (ProjectID = 1 and ScriptID = 2174 and ScriptID = 2174) points to the data row identified by ().
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:0) identified by (RID = (1:2694:0) ScriptID = 2178) has index values (ProjectID = 1 and ScriptID = 2178).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:1) identified by (RID = (1:2694:1) ScriptID = 2179) has index values (ProjectID = 1 and ScriptID = 2179).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:2) identified by (RID = (1:2694:2) ScriptID = 2180) has index values (ProjectID = 1 and ScriptID = 2180).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:3) identified by (RID = (1:2694:3) ScriptID = 2181) has index values (ProjectID = 1 and ScriptID = 2181).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:4) identified by (RID = (1:2694:4) ScriptID = 2182) has index values (ProjectID = 1 and ScriptID = 2182).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:5) identified by (RID = (1:2694:5) ScriptID = 2183) has index values (ProjectID = 1 and ScriptID = 2183).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:6) identified by (RID = (1:2694:6) ScriptID = 2184) has index values (ProjectID = 1 and ScriptID = 2184).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:7) identified by (RID = (1:2694:7) ScriptID = 2185) has index values (ProjectID = 1 and ScriptID = 2185).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:8) identified by (RID = (1:2694:8) ScriptID = 2186) has index values (ProjectID = 1 and ScriptID = 2186).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:9) identified by (RID = (1:2694:9) ScriptID = 2187) has index values (ProjectID = 1 and ScriptID = 2187).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:10) identified by (RID = (1:2694:10) ScriptID = 2188) has index values (ProjectID = 1 and ScriptID = 2188).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:11) identified by (RID = (1:2694:11) ScriptID = 2189) has index values (ProjectID = 1 and ScriptID = 2189).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:12) identified by (RID = (1:2694:12) ScriptID = 2190) has index values (ProjectID = 1 and ScriptID = 2190).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:13) identified by (RID = (1:2694:13) ScriptID = 2191) has index values (ProjectID = 1 and ScriptID = 2191).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:14) identified by (RID = (1:2694:14) ScriptID = 2192) has index values (ProjectID = 1 and ScriptID = 2192).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:15) identified by (RID = (1:2694:15) ScriptID = 2193) has index values (ProjectID = 1 and ScriptID = 2193).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:16) identified by (RID = (1:2694:16) ScriptID = 2194) has index values (ProjectID = 1 and ScriptID = 2194).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:17) identified by (RID = (1:2694:17) ScriptID = 2195) has index values (ProjectID = 1 and ScriptID = 2195).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:18) identified by (RID = (1:2694:18) ScriptID = 2196) has index values (ProjectID = 1 and ScriptID = 2196).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:19) identified by (RID = (1:2694:19) ScriptID = 2197) has index values (ProjectID = 1 and ScriptID = 2197).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:20) identified by (RID = (1:2694:20) ScriptID = 2198) has index values (ProjectID = 1 and ScriptID = 2198).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:21) identified by (RID = (1:2694:21) ScriptID = 2199) has index values (ProjectID = 1 and ScriptID = 2199).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:22) identified by (RID = (1:2694:22) ScriptID = 2200) has index values (ProjectID = 1 and ScriptID = 2200).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:23) identified by (RID = (1:2694:23) ScriptID = 2204) has index values (ProjectID = 1 and ScriptID = 2204).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:24) identified by (RID = (1:2694:24) ScriptID = 2205) has index values (ProjectID = 1 and ScriptID = 2205).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:25) identified by (RID = (1:2694:25) ScriptID = 2207) has index values (ProjectID = 1 and ScriptID = 2207).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:26) identified by (RID = (1:2694:26) ScriptID = 2209) has index values (ProjectID = 1 and ScriptID = 2209).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:27) identified by (RID = (1:2694:27) ScriptID = 2210) has index values (ProjectID = 1 and ScriptID = 2210).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:28) identified by (RID = (1:2694:28) ScriptID = 2211) has index values (ProjectID = 1 and ScriptID = 2211).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tblScript' (ID 848774131). Missing or invalid key in index 'XIF3tblScript' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2694:29) identified by (RID = (1:2694:29) ScriptID = 2212) has index values (ProjectID = 1 and ScriptID = 2212).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.XIF3tblScript' (ID 848774131) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3609:105) with values (ProjectID = 1 and ScriptID = 2170) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.XIF3tblScript' (ID 848774131) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3609:106) with values (ProjectID = 1 and ScriptID = 2171) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.XIF3tblScript' (ID 848774131) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3609:107) with values (ProjectID = 1 and ScriptID = 2173) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'LDAC_Figgie_Corrupted', index 'tblScript.XIF3tblScript' (ID 848774131) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:3609:108) with values (ProjectID = 1 and ScriptID = 2174) points to the data row identified by ().
There are 2234 rows in 52 pages for object 'tblScript'.
CHECKTABLE found 0 allocation errors and 68 consistency errors in table 'tblScript' (object ID 848774131).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (LDAC_Figgie_Corrupted.dbo.tblScript ).

View 6 Replies View Related

Possible Index Corruption

Oct 16, 2007

Hi there,

Firstly to give you some background. I’m working for a small company who should (but can’t) employ someone to look after what is becoming a huge database.

I work as a Web Developer and as such my DBA skills will not win any awards!!! I know how to write Stored Procedures and SQL....but I’m not up to speed keeping things working under the hood!

Just recently when deleting lines through SQL Server Management Studio, I am getting and error: could not delete. Possible index corruption. Run DBCC CHECKDB.

Now in the past I did run the above, and the problem still remains. More recently I have clicked on the index and clicked "rebuild". In one such case the fragmentation of the index had reached 92%!!!

There is no maintenance plan as such in place for our DB, and we have several tables with 3+ million lines (Maybe 30-40 tables in the entire DB). Are we crazy??? Are we also very lucky to date that nothing serious has gone wrong?

Is it time to get a DBA in for a few days to sort the above!!!! (All the DBA contractors say yes...)

Thanks in advance.

Justin

View 12 Replies View Related

Index Corruption Issues

Jul 20, 2005

We are having some troubles with corrupt indexes on our SQL 2000dbase.It is only affecting 2 tables out of about 150 we have.These 2 tables are heavily used.We have run dbcc repairs; dropped and recreated indexes but theproblem persistsIs it possible that this ongoing problem is indicative of a hardwareproblem.If so how could we diagnose this?here is a sample of the dbcc check against one of the tables whoseindexes we are having trouble with:thanksJ.C. ClayServer: Msg 8951, Level 16, State 1, Line 1Table error: Table 'page_views' (ID 1436024347). Missing or invalidkey in index 'IX_sessionid' (ID 7) for the row:Server: Msg 8955, Level 16, State 1, Line 1Data row (1:42151:27) identified by (RID = (1:42151:27) ) has indexvalues (session_id = B89F855E-CBB7-4874-A3BD-8D8827ED1481@�_).Server: Msg 8951, Level 16, State 1, Line 1Table error: Table 'page_views' (ID 1436024347). Missing or invalidkey in index 'IX_page_views_nav' (ID 8) for the row:Server: Msg 8955, Level 16, State 1, Line 1Data row (1:42151:27) identified by (RID = (1:42151:27) ) has indexvalues (navigation_id = A9E17BF3-41A6-43EF-8FD6-15C5B5E5E744@�_).Server: Msg 8951, Level 16, State 1, Line 1Table error: Table 'page_views' (ID 1436024347). Missing or invalidkey in index 'IX_page_views_tab_nav' (ID 10) for the row:Server: Msg 8955, Level 16, State 1, Line 1Data row (1:42151:27) identified by (RID = (1:42151:27) ) has indexvalues (tab_navigation_id =6373D50E-EF0B-4084-B8A7-032653E262E2@�_).Server: Msg 8951, Level 16, State 1, Line 1Table error: Table 'page_views' (ID 1436024347). Missing or invalidkey in index 'IX_page_view_id' (ID 11) for the row:Server: Msg 8955, Level 16, State 1, Line 1Data row (1:42151:27) identified by (RID = (1:42151:27) ) has indexvalues (page_view_id = 431E5427-A688-4957-967B-A3466799D94E@�_).DBCC results for 'page_views'.There are 958422 rows in 54595 pages for object 'page_views'.CHECKTABLE found 0 allocation errors and 4 consistency errors in table'page_views' (object ID 1436024347).repair_fast is the minimum repair level for the errors found by DBCCCHECKTABLE (profound.dbo.page_views ).

View 1 Replies View Related

Index Corruption Not Getting Fixed By DBREINDEX

Jan 30, 2006

Rob writes "We have had an on-going problem in our production database. It appears to all be index corruption. We've opened a PSS with Microsoft, but I figured I'd post here also. We're getting 604,605 errors as well as DBCC CHECKDB errors. All reports are that either REPAIR_REBUILD or REPAIR_FAST will fix the problem. Since putting the database into single_user mode is not an option at this time, we've just been rebuilding the problem indexes with DBCC DBREINDEX. This typically fixes the problem. Microsoft PSS says they believe that it's hardware problems. We're in the process of updating firmware on our storage device. (MSA 1000) This is a clustered machine. Tonight, our index rebuilds completed successfully, but a DBCC CHECKTABLE failed with 8951 and 8955 errors with the REPAIR_FAST option being supplied. I've rebuilt all the indexes on the table, but the DBCC CHECKTABLE still reports with errors. As a test, I DTS'd a copy of this table to make sure that I would at least be able to run a select * on it. That worked okay. My question is the following: Does the repair option for DBCC CHECKDB/TABLE do something that DBCC DBREINDEX doesn't? Thanks in advance! Rob P.S. This is a Siebel environment. :("

View 3 Replies View Related

Table Corruption

Jun 28, 2001

I have a database with a corrupt table and no matter what I do (dbcc's and rebuilding indexes), there are row fetch errors still occurring daily. My solution now is just to drop the table and recreate it.
Is it as simple as copying the data out of the original table, dropping the original table, and recreating the original table? What about the pointers to other pages? Referential integrety? Please give me a good reference for this subject or let me know. Thank you?

View 1 Replies View Related

Table Corruption...

Oct 3, 2005

I get the following errors when I ran dbcc checkdb..

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13015). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13039). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 18099105, index ID 0: Page (1:13015) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 18099105, index ID 1. Page (1:12777) is missing a reference from previous page (1:12567). Possible chain linkage problem.

and

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 562101043, index ID 2. The high key value on page (1:1779) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:13072).

What does it mean and how can i resolve them....
Database went into suspect mode , is this the likely cause..

View 20 Replies View Related

Table Corruption?

Jul 23, 2005

I have a table in my database called Users:CREATE TABLE [Users] ([UserID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Users_UserID]DEFAULT (newid()),[UserName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[password] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[EmailAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_ASNOT NULL ,[ValidFrom] [datetime] NOT NULL ,[ValidTo] [datetime] NULL ,[passwordSalt] [bigint] NOT NULL ,[FullName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[CreatorUserID] [uniqueidentifier] NOT NULL ,[DeletorUserID] [uniqueidentifier] NULL ,CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED([UserID],[]) ON [PRIMARY] ,CONSTRAINT [UX_Users_UserName] UNIQUE NONCLUSTERED([UserName]) ON [PRIMARY] ,CONSTRAINT [FK_Users_UsersCreator] FOREIGN KEY([CreatorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [FK_Users_UsersDeletor] FOREIGN KEY([DeletorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [CK_Users_Finished] CHECK ([ValidTo] is null and[DeletorUserID] is null or ((not([ValidTo] is null))) and((not([DeletorUserID] is null)))),CONSTRAINT [CK_Users_ValidDates] CHECK ([ValidFrom] <= [ValidTo])) ON [PRIMARY]GOIf you're looking at the Primary Key constraint above, you can probablyalready see the problem (this script was produced by Query Analyzer).If I try to get query analyzer to just script the PK, I get thefollowing error message:[SQL-DMO]The name '' is not a valid object identifier, or is not avalid format for this property or method.I've googled for this phrase, and cannot locate it. If I drop all ofthe constraints in my database, and reapply the constraints to Usersusing the following script:alter table Users add constraintDF_Users_UserID DEFAULT NEWID() FOR UserIDgoalter table Users add constraintPK_Users PRIMARY KEY(UserID) on [PRIMARY]goalter table Users add constraintUX_Users_UserName UNIQUE(UserName)goalter table Users add constraintCK_Users_ValidDates CHECK(ValidFrom <= ValidTo)goalter table Users add constraintCK_Users_Finished CHECK((ValidTo is null andDeletorUserID is null)or(not ValidTo is null andnot DeletorUserID is null))goalter table Users add constraintFK_Users_UsersCreator FOREIGN KEY(CreatorUserID)REFERENCES Users(UserID)goalter table Users add constraintFK_Users_UsersDeletor FOREIGN KEY(DeletorUserID)REFERENCES Users(UserID)goI *still* have this wierd PK. I've checked through both theINFORMATION_SCHEMA views and directly through the system tables, and sofar as they are concerned there is only a single column (UserID) actingas part of the PK.So, any ideas? It appears to be preventing us from setting upreplication. Thankfully, it also occurs in a restored backup of the DB,so I'll be able to reproduce/attempt fixes to my hearts content.Thanks,Damien

View 10 Replies View Related

Table Corruption After Sp_rename

Oct 5, 2000

Sql 7. SP 2

After renaming a table Table_tbl to Table_old
and vise-versa.

When selecting from Table_old (for yesterday's data)
I get errors stating that Page belongs to Table_tbl.

Any suggestions on how to successfully rename Old to New, etc.
And not have cross-linked data pages??

View 1 Replies View Related

Table Corruption - DBCC Output

Dec 14, 2005

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1513928615, index ID 0: Page (3:33709) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1513928615, index ID 0, page (3:33709), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 95 and 30.
DBCC results for 'Result'.
There are 41589306 rows in 660667 pages for object 'Result'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Result' (object ID 1513928615).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (LASAR2.dbo.Result ).

View 12 Replies View Related

Apparent Data Corruption In Table

Apr 17, 2007

Hi,
I use SQL Server 2000 as a backend database for my Access Front end. It has been working fine for months with no problems.
This morning I arrived in work to find a problem with a table called "TimeSheets". If I try to access the table through Access I get an ODBC timeout error. Likewise, if I open the table in Enterprise manager, it opens fine, but any sorts or if I try to go to the last record, it returns the following error: "[Microsoft][ODBC SQL Server Driver] Timout expired".

So I tried to query the table in SQL Query Analyzer. Everytime it freezes on record 15,936. The table holds 17,643 records.

I tried running DBCC CHECKTABLE ('Timesheets'), and get the following message:

DBCC results for 'Timesheet - Item'.
There are 17643 rows in 401 pages for object 'Timesheet - Item'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I can't see any error messages, but by now I'm reaching the limit of my knowledge of SQL Server.

So, can anybody please help me with this? Any suggestions why my table has apparently become corrupted? Any suggestions how I might fix it?

Thanks a lot for any help

Colin

View 4 Replies View Related

Table Corruption On Adjust Table

Mar 15, 2006

I have an old application running on SQL Server 6.5 (6.50.416) that has a number of internal issues - inability to dump the transaction logs (would dump 9gb out of a 10gb datbase everytime regardless of truncating the logs), transaction log size of 0 even though 700mb allocated, very long DBCC's (though they complete properly).

I am trying to salvage the database by using DTS to copy out the schema, data, sp's, etc. into a new database.

I have the conversion running without error. Data usage goes from almost 10gb down to under 3gb and the transaction logs are now working.

However, when I use DBCC checkdb on the new database, I get the following (just a small sample):

Checking 524528902
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25930 row#=10); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25930 row#=10 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25941 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25941 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x1b20a800, pageno = 25941, status = 0xD, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1794. The offset should be 1384.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25967 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25967 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x22ab9000, pageno = 25967, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1667. The offset should be 1345.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26146 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26146 row#=0 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26151 row#=5); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26151 row#=5 computed row length=521 row length on page=520
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26163 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26163 row#=0 computed row length=546 row length on page=545
Msg 2596, Level 16, State 1
Page pointer = 0x218ba800, pageno = 26163, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1387. The offset should be 577.
etc...

The errors occur only on 3 specific user tables, and are consistent each time I try the conversion. Same exact page numbers and offsets (page pointers are of course different). I do not get any DBCC errors on the original DB at all. I can do select's on the tables without issue, and they seem to have the correct amount of data (did row counts and sums of various columns)

Any insight into what might be causing this or what the actual error is would be welcome.

Thanks,

Brett

View 7 Replies View Related

The Index Entry For Row ID Was Not Found In Index ID 3, Of Table 357576312

Jul 9, 2004

Hi,

I'm running a merge replication on a sql2k machine to 6 sql2k subscribers.
Since a few day's only one of the merge agents fail's with the following error:

The merge process could not retrieve generation information at the 'Subscriber'.
The index entry for row ID was not found in index ID 3, of table 357576312, in database 'PBB006'.

All DBCC CHECKDB command's return 0 errors :confused:
I'm not sure if the table that's referred to in the message is on the distribution side or the subscribers side? A select * from sysobjects where id=357576312 gives different results on both sides . .

Any ideas as to what is causing this error?

View 3 Replies View Related

Advantages Of Using Nonclustered Index After Using Clustered Index On One Table

Jul 3, 2006

Hi everyone,
When we create a clustered index firstly, and then is it advantageous to create another index which is nonclustered ??
In my opinion, yes it is. Because, since we use clustered index first, our rows are sorted and so while using nonclustered index on this data file, finding adress of the record on this sorted data is really easier than finding adress of the record on unsorted data, is not it ??

Thanks

View 4 Replies View Related

What Are Reasons For Dumpfiles In Server

Jun 22, 2015

What are the reasons for dumpfiles in sql server?All databases have no corruption when I ran DBCC checkdb (system & user dbs) but there were dumpfiles SqlDumpExceptionHandler: Process 9999 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.what are the main reasons for acess violation dumpfiles?

View 6 Replies View Related

Reasons To Go SQL 2005 Over SQL 2000

Aug 11, 2006

Hi all,

I am working with an outside consultant to upgrade our SQL 7 instance. He wants to upgrade to SQL 2000 and I want to go to SQL 2005. I want to have concrete reasons backed up with documentation as to why we should go SQL 2005 as opposed to SQL 2000.

For eg. support (why 2005 is better, ie. longer support), security(More secure, documentation), management, stability (number of patches released last year) etc.

I'd really appreciate it if someone could point me to an appropriate resource.

Thanks all,

SA.

View 6 Replies View Related

For Security Reasons DTD Is Prohibited In This XML Document

Oct 9, 2007

After viewing many reports in reportviewer, I sporadically get the following error message. Each attempt to access any report in report viewer after the error message first appears results in the same error message for a bit of time until it appears to reset itself. I have read that this may be related to running out of memory for report processing... We have 2GB of RAM. How can I prevent this from happening or force the system to free up some memory if it is exhausing the available memory?

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

View 1 Replies View Related

For Security Reasons DTD Is Prohibited In This XML Document

Apr 4, 2006

I have seen one other post about this and using IP addressing rather that DNS names - I am using DNS.

I have a large report that runs fine in report manager, but as soon as I try and export it to Excel it takes an age to run and I get the above error.

Any ideas anyone?

Oh, and I export loads of other reports to Excel with no problems on the same server.

View 18 Replies View Related

For Security Reasons DTD Is Prohibited In This XML Document

May 1, 2007

I am getting this error while running a very large dataset. Please help..

The full description of the error is : "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method."

I am having hard time figuring out a solution for this. I am using sql 05, SSRS 05, Report viewer

View 3 Replies View Related

For Security Reasons DTD Is Prohibited In This XML Document.

Jan 10, 2007

When we develop with the Microsoft SQL Server 2005 Reporting Service.
We got the exception on some reports.

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on
XmlReaderSettings to false and pass the settings into XmlReader.Create method.

Ther report renders well first time, but if we click the title to sort the report, it will throw the exception.

And It occurred that we use IE6 and IE7 to view the report at same time, but if we use the same version brower, there are no exception.
Can somebody help me?

My development��s environment :

Windows XP English Professional + SP2
Microsoft SQL Server 2005 Development version + SP 1 + SP 2
Microsoft Visual Studio 2005 Professional Version 8.0.50727.51 (QFE.050727-5100) + SP1
Microsoft .NET Framework Version 2.0.50727

View 3 Replies View Related

A Strong SA Password Is Required For Security Reasons?

Apr 3, 2005

When I try to install SQL Server I get the follwing message when I click on the installation file :

A strong SA password is required for security
reasons.

Please use SAPWD
switch to supply the same. Refer to readme

for more details.
Setup will now exit.

I've checked the readme but can't really find any info on how to fix this.
I don't know what password this SA password is nor how to change it.
Can anyone help me out?

View 6 Replies View Related

DB Engine :: Database Mail Could Not Be Sent - Rejected Due To Policy Reasons

Jul 29, 2015

I have configured DB Mail in our SQL Server Management Studio. But I am getting the following Error. Also I am getting Same Error while doing SSRS Report Subscription via mail. (Same Server).

Error Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2015-07-21T04:22:24). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: Mail from
analytics@xyz.com rejected for policy reasons.).
)

For your additional info: In SSIS I can able to send email using Mail Task.

View 5 Replies View Related

Root Element MIssing && For Security Reasons DTD Is Prohibited In This XML Document

Aug 10, 2007

This error comes up in the print preview and nothing prints.

We are using VS-2005, SQL 2005 and SSRS 2005.

We had the same problem yesterday , so we have reinstalled IIS, .Net Framework 2.0 and Reporting Services, then reconfigured RS security, uploaded all the reports and enabled remote errors. After doing everything this error was gone and we were operating pretty fine.

Suddenly just we started getting the same annoying message."ROOT ELEMENT MISSING" from Report Server and from Report Manager we have "
For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. "

Please Help. I need to fix this ASAP.

View 8 Replies View Related

Windows Server 2003 And Reporting Services Error: For Security Reasons DTD Is Prohibited In This XML Document.

Mar 29, 2007

I do a clean install of SQL Server + RS + SP1 with standard setup on Windows Server 2003. I create a simple report (select * from aTable). This report (actually any report) shows the error message "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method."

This has to do with security settings in Windows Server 2003. On Windows XP everything works fine.

Any help would be greatly appreciated. Thanks!

Edit: The reports do work in the preview tab in BIDS.

View 5 Replies View Related

Difference Between Index Seek && Index Scan && Index Lookup Operations?

Oct 20, 2006

please explain the differences btween this logical & phisicall operations that we can see therir graphical icons in execution plan tab in Management Studio

thank you in advance

View 3 Replies View Related

How To Create Index On Table Variable (Table Don't Have Primary Key)

Feb 26, 2008

Hi all,

my stored procedure have one table variable (@t_Replenishment_Rpt).I want to create an Index on this table variable.please advise any of them in this loop...
below is my table variable and I need to create 3 indexes on this...

DECLARE @t_Replenishment_Rpt TABLE
(
Item_Nbr varchar(25) NULL,
Item_Desc varchar(255) NULL,
Trx_Date datetime NULL,
Balance int NULL,
Trx_Type char(10) NULL,
Issue_Type char(10) NULL,
Location char(25) NULL,
Min_Stock int NULL,
Order_Qty int NULL,
Unit char(10) NULL,
Issue_Qty int NULL,
Vendor varchar(10) NULL,
WO_Nbr varchar(10) NULL,
Lead_Time int NULL,
PO_Nbr char(10) NULL,
PO_Status char(10) NULL,
Currency char(10) NULL,
Last_Cost money NULL,
Dept_No varchar(20) NULL,
MSDSNbr varchar(10) NULL,
VendorName varchar(50) NULL,
Reviewed varchar(20) NULL
)

I tryed all below senarios...it is giving error...

--Indexing the @t_Replenishment_Rpt table on the column Names Item Number, Vender , Department Number
--EXEC sp_executesql(CREATE UNIQUE CLUSTERED INDEX Replenishment_index ON @t_Replenishment_Rpt (Item_Nbr))
--CREATE UNIQUE CLUSTERED INDEX Idx1 ON @t_Replenishment_Rpt.Item_Nbr
INDEX_COL ( '@t_Replenishment_Rpt' , ind_Replenishment_id , Item_Nbr )
--EXEC sp_executesql('SELECT INDEXPROPERTY('+ '@t_Replenishment_Rpt' + ', ' + 'Item_Nbr' + ',' + 'IsPadIndex' + ')')
--EXEC sp_executesql(SELECT INDEXPROPERTY('@t_Replenishment_Rpt', 'Vendor','IsPadIndex'))
--EXEC sp_executesql(SELECT INDEXPROPERTY('@t_Replenishment_Rpt', 'Dept_No','IsPadIndex'))

View 3 Replies View Related

Index Seek, Index Scan, Table Scan

Oct 4, 2007

Hey,

what is the difference between Table Scan und Index Scan?

I find no difitions in the internet

Finchen

View 5 Replies View Related

What Is Table Scan, Index Scan And Index Seek??

Sep 21, 2007

Hi,
I want to know wht is a

TABLE SCAN
INDEX SCAN
INDEX SEEKand When they are used, Wht is the difference between all these.????

View 5 Replies View Related

How Do I Add A Index To A Table

May 21, 2008

How to add a index to a table or to multiple tables but there are no primary keys on them

Thanks
Karen

View 3 Replies View Related