Does anyone know a good way to test a SQL data connection quickly? Right now all I know to do is attempt to collect from a table and check for empty, but it's pretty slow. Perhaps there's somewhere to set the timeout? I'm wanting to modify my existing app to handle times when the server is being rebooted or we have network issues. All I've found thus far or checking connection of any kind is Connection.Connected, which is only useful for losing network connection completely. Any ideas/suggestions?

Report
All responses (
Answers (