locked
Deferred name resolution does not work for mirrored or offline databases RRS feed

  • Question

  • Dear all,

    We use sql server 2005 SP1. We have a principal server and a mirroring server. We would like to create store procedure on master db that calls stored procedures in both principal and mirroring server. Unfortunately, it seems that we encounter the problem that we cannot refer to mirror database.

    The database "XXXXXXXXX" cannot be opened. It is acting as a mirror database.

    I have checked the web and find the following.
    Please refer to
    MSIT - MSO: Deferred name resolution does not work for mirrored or offline databases
    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254091


    The suggestion provided require us to upgrade current system to SQL Server 2008. However, we don't have it.
    We would like to ask for help

    Thanks
    Friday, August 7, 2009 8:01 AM

Answers

  • it's a bit dodgy and it may not fit your solution, but try & make the procedure in master dynamic sql so that you won't try to parse it to resolve names!
    • Marked as answer by winipcfg Tuesday, August 11, 2009 1:42 AM
    Friday, August 7, 2009 12:20 PM