In [!INCLUDE ssManStudioFull]: Change the Operating mode option to High safety without automatic failover (synchronous) by using the Mirroring Page of the Database Properties dialog box. For ...

INCLUDE ssNoVersion] automatically recompiles stored procedures, triggers, and user-defined functions when advantageous. There are various reasons the database engine might choose to recompile objects ...