Post reply

DELETE Issue - Anyboby know why?

  • May 9, 2007 at 8:20 am

    #173586

    Anybody seen this one before?

     

    Cannot retrieve row from page (4:2268) by RID because the slotid (0) is not valid

    Connection broken

     

    This happens when i try to run a delete statement thus

    DELETE FROM Mytable

    Where Field1 = 'X' AND Filed2 IN (SELECT Top 1 from MyTable)

     

  • May 9, 2007 at 9:05 am

    #705258

    You've posted in the SQL 2005 forum... please confirm that you are using SQL Server 2005.

    Thanks

    John

  • May 10, 2007 at 3:40 am

    #705446

    I am usiing SQL 2000. Is there a SQL 2000 forum?

  • May 10, 2007 at 4:02 am

    #705447

    I'm guessing you haven't applied Service Pack 4?  The following link refers: you can also find it simply by googling your error message.  That should be the first thing you try, because you get an answer much quicker!

    http://support.microsoft.com/kb/814889

    John

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply