NEED UPDATE STATS to run Synchronously

• Express12

  SSCoach

  Points: 18526

  More actions

  April 10, 2007 at 8:51 am

  #62643

  Anyone know how to make an UPDATE STATISTICS process 'synchronous'?  

  We are experiencing an issue in a DTS pkg whereby SQLTask1 (includes UPDATE STATS followed by a RECOMPILE) spawns an asynch task and instantaneously moves to the next SQLTask2 in the DTS pkg.  (the dependancy is 'On Success'.

  We want the contents of SQLTASK1 to 'complete' first before moving to SQLTask2 therefore -- need a mechanism to make the UPDATE STATISTICS to run synchronously.

  Any ideas?

   

  BT

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  April 23, 2007 at 1:24 pm

  #702004

  The process is already syncronous and serial .. step 1 executes and conditionally then step 2 executes.

  What is the real issue or problem that you are having ?

  (oh, I'd also add sp_refreshview in addition to sp_recompile as well !)

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."