Thanx a lot for the info.
I have asp.net web application with sql server. I am using sqlconnection object for making the connections and I am closing those connection objects immediately after using them. I am not getting any error logs from sql server. Can u tell me how & where I can check them.
quote:Originally posted by r_ganesh76
if you are using ado, make sure that you do a connection.Close() each time. Otherwise, the connections will automatically be closed by SQL Server as and when required. Aso check the SQL Error log