"DWalker" <none@none.com> wrote in message
news:eRW7s8g1HHA.4584@TK2MSFTNGP03.phx.gbl...
>
> Oops, I accidentally put this in the wrong newsgroup the first time. I
> think this is a better location. Sorry for the double-post.
>
>
>
> I occasionally need to create or alter a view that references a linked
> server, where the linked server is not currently online (or my Internet
> connection is not currently connected, or whatever).
>
> An "Alter View" statement that references a linked server name will fail
> with "Could not find server", "Login Failed" or other errors, if the
> server
> is not accessible at the moment.
>
> I sometimes don't care about this problem at the time that I *define* the
> view (or stored procedure, or user-defined function); when I *run* the
> view, procedure, or function, the linked server will be there, and things
> will work.
>
> I can't find how to get around this, which seems like a limitation of the
> "Create View" and "Alter View" commands.
>
> Thanks for any suggestions.
>
> David Walker