AZURE SQL Data Sync

2017-07-09 Thread Scott Barnes
Anyone have experience using Azure SQL Data Sync? Any "If they only put this on the back of the brochure" moments that left you with buyers remorse? --- Regards, Scott Barnes http://www.riagenic.com

RE: Global SQL Server timeout

2017-07-09 Thread 罗格雷格博士
Yep, no connection timeout != command timeout. You need to have a command timeout set on each command that’s created. Sucks if the devs didn’t do that up front but I see this often. Works great until queries take more than 30 seconds. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) offic

Re: Global SQL Server timeout

2017-07-09 Thread DotNet Dude
I don't recall such an ability. You'll probably have to go the helper method and config value route - fun fun! On Monday, 10 July 2017, Greg Keogh wrote: > Folks, I have some old code that uses a mixture of Enterprise Library 5 > and traditional ADO.NET classes. On some machines I'm getting comm

Re: Global SQL Server timeout

2017-07-09 Thread Preet Sangha
;Connection Timeout=XX in the connection string where XX is in seconds is the way to do it in a single connection string. I don't know about EL regards, Preet, in Auckland NZ On 10 July 2017 at 14:27, Greg Keogh wrote: > Folks, I have some old code that uses a mixture of Enterprise Library

Global SQL Server timeout

2017-07-09 Thread Greg Keogh
Folks, I have some old code that uses a mixture of Enterprise Library 5 and traditional ADO.NET classes. On some machines I'm getting command timeouts at 30 seconds. Is there a way of globally changing the timeout for all commands on the connection, perhaps by changing the connection string? I cou