Post reply

1 row insert wont fail & continues to run?

  • July 7, 2009 at 7:47 am

    #131782

    I am doing the following:

    insert into table1 (set_id,lbl_key,ID,Permit,note_id,tabular,key)

    values(11027630,3674743,602,0,NULL,NULL,NULL)

    I have checked the logs but I find nothing, the insert just runs and runs with no failure. not sure where to start?

    any ideas?

    Thanks a bunch

  • July 7, 2009 at 8:01 am

    #1021071

    Sounds like you are being blocked by another process.

    Run your insert again

    then

    exec sp_whoo

    You should see the Session you are being blocked by in the 'BlkBy' column.

    Either kill it or commit it.


    Clear Sky SQL
    My Blog[/url]

  • July 7, 2009 at 8:04 am

    #1021073

    I agree it sounds like blocking but I think he meant sp_who not sp_whoo..

    CEWII

  • July 7, 2009 at 8:09 am

    #1021079

    also check if there is a trigger against the table - especially a badly coded one - perhaps with nested trigger calls

    MVDBA

  • July 7, 2009 at 8:09 am

    #1021080

    good call guys...that was the ticket...thanks should have thought of that one

  • July 7, 2009 at 8:14 am

    #1021084

    Elliott (7/7/2009)

    I agree it sounds like blocking but I think he meant sp_who not sp_whoo..

    CEWII

    Serves me right for eating Haribo at my desk 😀


    Clear Sky SQL
    My Blog[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

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