We've had SQL 2005 mirroring running successfully for a while now, but the issue I have is our applications reference the primary server by name directly and when the mirror fails over to box #2 I'm ...

I'm a sysadmin but nothing to do with DB's, we have DBA's for that. I want to automate windows security patches for our servers and when I get to this pair or mirrored SQL db servers, my DBA doesn't ...