Hi,
My DB is in SQL2k3 Sever, has linked SQL2005 server.
DB in 2k3 has views, that fetches data from views in DB
in 2005 linked server.
Now this 2005 DB is mirrored. When SQL2005 server has downtime
my app does not work,as it can find linked server.
How do i handle that in my SQL 2k3 DB's views..?
Please let me know what my approach should be in this case...