One of the applications using SMO that is running in production is giving a timeout error on a long running query. I have access to code and can set the Connection.StatementTimeOut to 0 or a high enough value. But is there a .config or any configuration file associated with SMO wherein I can specify this property ? The thought is update or deploy this file in the production environment instead of deploying code.
Asked
Active
Viewed 32 times
1
-
see this:https://stackoverflow.com/questions/4308417/connection-timeout-for-sql-server – TheGameiswar Aug 03 '17 at 17:36
-
Possible duplicate of [Connection timeout for SQL server](https://stackoverflow.com/questions/4308417/connection-timeout-for-sql-server) – TheGameiswar Aug 03 '17 at 17:36