-
Linked servers and application security
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 :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|