Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2008-07-01 : 12:36:50
|
| Is there a way to find the connection command timeout setting from the server side?We have a vendor supplied app that we do not have source code for, so we cannot look there to find the timeout.CODO ERGO SUM |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 12:50:10
|
| Maybe in Event log. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-01 : 13:53:22
|
which one is it? a connection timeout or command timeout? it's 2 different things  is it a .net app? if it is you could use reflector to search for it in the dll's_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-01 : 18:09:20
|
| I am interested in the command timeout. I don't know the nature of the app since it was supplied by a vendor.Is there anyway to determine it only from the SQL Server side?CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-01 : 18:18:29
|
You can't determine it from the SQL Server side as it never gets passed to SQL Server. It's purely on the client side. The client is what breaks the connection when the timeout value has been surpassed.I highly doubt that you'll find the info in Event Viewer as sodeep suggested. I'd bet quite a bit of money against it.  Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-01 : 22:59:16
|
| Check app's config file, log file and registry keys if it has any. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-02 : 11:31:11
|
quote:
Originally posted by rmiao
Check app's config file, log file and registry keys if it has any.
I am only interested in things I can see from the server side. As I suspected, it sounds like this information is not passed to the server so that is fine with me.I can let developers deal with looking from the client side.CODO ERGO SUM |
|
|
|
|
|
|
Finding Connection Command Timeout