March 10, 2006 at 5:17 pm
I enter null into a column (yes nulls are allowed) and get this error on subsequent updates:
Server: Msg 644, Level 21, State 5, Line 1
Could not find the index entry for RID '168f500100' in index page (1:1428), index ID 5, database 'mydb'.
Connection Broken
I tried using Crtl+0 in Enterprise Manager and it does enter <NULL> but if I try to enter anything else in that column I get the error.
Same with Query Analyzer, this also enters null into the column but any subsequent entries in that column fail, entries into other columns of same row are ok:
declare @test-2 varchar (75) -- note: not initiated
update myTable set myColumn = @test-2 where id = 1
--or
update myTable set myColumn = null where id = 1
What's goin' on here?
March 10, 2006 at 5:36 pm
when was the last time that you ran dbcc checkdb on that DB? were there any errors?
* Noel
March 13, 2006 at 3:59 pm
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mydb'.
March 13, 2006 at 4:30 pm
I think the problem had to do with referencial integrity.
The problem no longer exists.
Thank you for your time anyway noeld.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply