This is the third in a series of posts on timeouts
SQL Server Management Studio ( SSMS)
For those that use the Designer built into SSMS to make structural table changes, the Designer Option panel is a good place to go and make sure that the default settings are what you want them to be.
Here is what that screen looks:
- Here we changed the “Transaction Time-out after:” from the default of 30 seconds to 90 seconds
I think outside of the Database World and specifically SQL Server, it is OK to use the phrase & words, but I think for a tool that targets SQL Server and only that table, a bit more care should be taken.
And, you likely ask why.
Grouping :- Override connection string time-out value for table designer updates
Phrase :- Transaction time-out after
Here are the difficulties that I have with the Group Label “Override connection string time-out value”
- We all know that the Connection String does not expose command execution nor lock timeout
- Command Execution can be set in the Connection or Command Object, but not in the actual connection string
- Because of this understanding, coders have to look into the code and set the timeouts
- They are not able to do so declaratively in the Web.config and thus not suffer the pain of recompile
- There is more than enough misappropriation that Connection Open timeouts and Command Execution timeouts, are one the same
Microsoft – Connect
- Item # :- 3130697
- Link :- Link
Opened By: Daniel Adeniji
Date Opened:- 2017-March-25
Type :- Suggestion
Status :- Active
- Link :- Link