Linked Server : :Cannot start more transactions on this session"

• MI_DBA

  SSChasing Mays

  Points: 614

  More actions

  March 14, 2012 at 10:24 am

  #253048

  Hi All,

  I have a job on a production server A which has two steps:

  Step1: Inserts records older than one year from a databse on server B into a database on server A

  Step 2: Deletes those records from server B if step 1 was successful

  Problem is that step 1 is executing successfully however step 2 is 'showing' successful but is not deleting records from server B, job history has following message logged:

  OLE DB provider "SQLNCLI" for linked server "ServerB" returned message "Cannot start more transactions on this session.". [SQLSTATE 01000] (Message 7412). The step succeeded.

  I checked and found that if I try to delete records manually from server A then deletion is successful.

  Please suggest

  Need help urgently!!

  Thanks in advance.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 14, 2012 at 10:31 am

  #1459348

  Duplicate post.

  Replies here please

  -- Gianluca Sartori