Hi,



Im looking for procedure logic that says; 'Try this linked server, if
its there, great do stuff with it, but if its gone, do nothing and go to
the next step."



How do I trap an error message for a linked server call when the linked
server blows up?



John


--
DISCLAIMER

Confidentiality Note: This e-mail is intended only for the person or entity to
which it is addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. Dissemination,
distribution or copying of this e-mail or the information herein by anyone
other than the intended recipient, or an employee or agent responsible for
delivering the message to the intended recipient, is prohibited. If you have
received this e-mail in error, please notify us immediately (telephone
415-288-0544 or e-mail [Email address protected] and destroy the original
message and all copies.

Hall Capital Partners LLC reserves the right to monitor and review the content
of all e-mail communications sent and/or received by its employees.


MS Sql Server LazyDBA home page