IF, when a connection to SQL Server breaks, (CREATE CONNECTION myconn CONNSTRING "blah, blah, blah") due to a network interruption or timeout by the OS, etc. etc. ... all the views based on that connection will stop working. Does anyone out there have a solid way to test for the status of a connection (other than to attempt a query and trapping for a timeout error) to make sure the connection is still good?
My thought here is to test for the connection status and if broken, reconnect and rebuild the views that are based on it. Thanks Alec Gagne _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
