jgersic
Reputable Poster
We have a situation where users are performing wide open 'finds' on large tables using the web. The data does not come back immediately, so the user kills the window where the query is running but SQL keeps running the query.
Are there any switches/settings to set a timeout period for the DB - to kill a query, or DB connection if there is no response in a certain period of time? I have seen a setting for the serialized objects, but not for business data. Is there one?
Thanks,
John
Are there any switches/settings to set a timeout period for the DB - to kill a query, or DB connection if there is no response in a certain period of time? I have seen a setting for the serialized objects, but not for business data. Is there one?
Thanks,
John
