Re: Create view "disconnected" (correct group this time)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Well, I replied in microsoft.public.sqlserver.server. - RLF

"DWalker" <none@xxxxxxxx> wrote in message
news:eRW7s8g1HHA.4584@xxxxxxxxxxxxxxxxxxxxxxx

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


.

Relevant Pages

  • Create view "disconnected" (correct group this time)
    ... I accidentally put this in the wrong newsgroup the first time. ... connection is not currently connected, ... An "Alter View" statement that references a linked server name will fail ...
    (microsoft.public.sqlserver.connect)
  • First update to linked server fails
    ... I am accessing a linked server through a VPN connection. ... I am updating ... through an Access interface. ... The first time that I perform an update ...
    (microsoft.public.windows.server.sbs)
  • MS SQL 2005 to Sybase via Linked server
    ... I'm having an issue setting up a linked server connection on a new SQL 2005 ... The connection is working on the existing sql 2000 box. ... I enter all the sybase server info and use the "Test ...
    (microsoft.public.sqlserver.odbc)
  • Transaction with linked server
    ... When I open transaction with insert statement from linked server and that ... When I kill connection it ... transaction or kill connection without restarting? ... (MySQLServerColumn) ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked Server and Verify Connection
    ... instead just provide the details needed so a connection can be made to ... execute a query that refers to the linked server. ... >I need to verify the link was made before I start running any more code. ...
    (microsoft.public.sqlserver.mseq)