Search Result

I am using .net 3.0 and sql 2005.(using DAAB)
I am getting timeout error bcz query running more than 30 sec.
My question is if time out occured, what will happened on server.
What would be state of the running stored procedure.
Will it terminate or alive.

It will be very helpful for me.

Hi,
I have a query that takes 1 min 50 secs to execute in Query analyser
(SQL Server 2000).
When i execute this query from vb using ADO i get the 'Timeout
Expired' error.
I have tried setting the Connection.Time out property to the ADO
connection object but it doesn't work.
Can anybody tell me how can i set the Connection.Time out property in
both vb and SQL Server.

Thanks in advance...