Referencing Databases In SQL 2008 Mirrored Reporting <p>I have 2 databases.</p> <p>1 is a mirror of the other, <strong>EXCEPT</strong>, 1 has a table called <strong>DOG</strong> and the other has the same table but it is called <strong>DOG2</strong>.</p> <p>I have an ssrs report that references DOG..DOGID. </p> <p>Now when DOG goes down I want to use the connection string to DOG2, the only issue is my reference to DOG..ID will no longer be valid if I am connecting to DOG2. </p> <p>Is there a way in SQL code to make it so if DOG..DOGID is invalid use DOG2..DOGID?</p>