I am developing a SQL based SQL server centric application. ( SQL 7 )Applications is using a multiple linked servers to a different sources ( i.e. Oracle; DB2; Sybase ) located on different machines; multiple stored procedures based on the dynamic SQL. If the particular linked server is down, - the dynamically generated SQL string, should be changed.
That all was relatively simple :-). The complicated question is: how to define that the linked server is down?

Glen

P.S. Please do not submit suggestion like : "Use @@ERROR" ; "Open BOL and read" etc... The question is not as simple as it looks :-)