CommandTimeout

microsoft.public.dotnet.framework.adonet

23 Feb 2006 10:01 AM

Carl Howarth

Hello all,

Just a quick Q.... If my query reaches the command timeout limit I set, will
ADO.NET automatically kill the process on SQL Server?

Thanks

--
Carl Howarth

23 Feb 2006 11:22 AM

Val Mazur (MVP)

Carl,

Yes, process will be killed automatically and you will get an exception

--
Val Mazur
Microsoft MVP
http://xport.mvps.org

Show quote

"Carl Howarth" <CarlHowa***@discussions.microsoft.com> wrote in message
news:6A7B8B3E-1337-4046-A8CB-0762AA669A30@microsoft.com...
> Hello all,
>
> Just a quick Q.... If my query reaches the command timeout limit I set,
> will
> ADO.NET automatically kill the process on SQL Server?
>
> Thanks
> --
> Carl Howarth