I have two database servers
Server2, configured with mirroring. A single database,
MirrorDB, is mirrored. There is another database on
OtherDB which is only present on
Server1 and is not mirrored.
OtherDB has a stored procedure named
SP_Z which refers to a table in
MirrorDB to compute some value.
Server1 is the principal for
SP_Z stored procedure in
OtherDB works perfectly, however when
MirrorDB fails over to
OtherDB fails as it can not open
How do I solve this problem?