Mirroring Failover - Updating Stored Procedures

• Jafar

  Mr or Mrs. 500

  Points: 520

  More actions

  June 4, 2008 at 3:00 pm

  #154413

  What's the simplest way of updating all stored procedures that reference the instance name of a partner in a database mirroring setup, so that when there's a failover, all my stored procedures will point to the new principal?

  Thanks! 😀

  Jafar

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 4, 2008 at 3:15 pm

  #824557

  Are you including "instancename" in your procedures ?

  
  * Noel