Create view "disconnected" (correct group this time)

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 WalkerWell, I replied in microsoft.public.sqlserver.server. - RLF
"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|||Hi David,
You can continue the communications under your other post in
microsoft.public.sqlserver.server. You are guaranteed to get Microsoft
assistance in MSDN managed newsgroup.
If you have any other questions or concerns, please feel free to let us
know.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============