Post reply

Awaiting command problem in sql server 2008

  • November 30, 2012 at 12:26 am

    #270866

    I have used begin transaction in stored procedure that sp used about 1500 To 2000 times in one day for insert the records in 4 tables, after record insertions into two tables fired the some triggers for updates the 3 to 4 tables records.some time my transaction come in sleeping mode. then i kill the transaction then insert the record.Plz tell the sol.

  • November 30, 2012 at 6:09 am

    #1564327

    Wow, I read that 3 times and I'm still not sure what you're asking. Could you possibly post the stored proc code and trigger code?

Viewing 2 posts - 1 through 1 (of 1 total)

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