Post reply

Unable to update records

  • August 25, 2010 at 9:05 am

    #222996

    I'm able to update 1 record at the time but not a bunch at once, I have a table with 250,000 records and I need to update a column and I'm not able to.

    I'm able to do this,

    Update tablexx

    Set Qty = 0

    where id in(select top 1 id from tablexx)

    But when I do this

    update tablexx

    Set Qty = 0

    Or

    Update tablexx

    set Qty = 0

    from Tablexx

    No luck, I left it yesterday running almost 3 hours and nothing, I tried setting server to single mode, ending services that may access the db and still no luck - the db itself is 400 meg..

    Any suggestions?

  • August 25, 2010 at 9:11 am

    #1211704

    Hi,

    Check whether Trigger is enabled for this table or not

    If so disable the trigger and check with ur code ,after finishing reenable the trigger

    There might be some other reasons aswell one of the reasons is trigger try this and come out

    Thanks

    Parthi

    Thanks
    Parthi

  • August 25, 2010 at 9:41 am

    #1211746

    It worked,

    There was a trigger, follow your suggestion, ran code again and "YES!" it worked..

    Thanks a lot..

  • August 25, 2010 at 9:49 am

    #1211752

    Dont forgot to reenable that trigger since it might have be wrriten for some other purpose.Ensure that it is enabled.

    Thanks

    Parthi

    Thanks
    Parthi

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

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