Archive for September 26th, 2006

ConnectionTimeout vs. CommandTimeout

I was asked the question today why a sql query was timing out.  A co-worker explained that he changed the ConnectionTimeout setting and it was still timing out.  I thought i’d post about the differences between CommandTimeout and ConnectionTimeout. ConnectionTimeout is the one specified in your connection string and it is the time it takes [...]