hi,
I have made a windows service in c#.net. By this service in database we delete some rows again insert them. Also with this table a trigger is associated on insert which does the same with a table in different database of same server. This service is working fine and database is being updated every second. The problem is after some time it gives timeout expired error by .Net sqlClient and does not update table until we restart service. Please assist what I m doing wrong and what should I do?
Thanks in advance
Dharmendra

__________________
Dharmendra
Software Engineer

Are you remembering to close the connection after you use it?
If you are using an explicit transaction, are you remembering to do a COMMIT?
Is something causing a DeadLock or Block somewhere?

--Jeff Moden

hi,
I scanned my code and the connections are closed everywhere after use aslo I m not using any explicit transaction. Ys I aslo guess there is something causing a DeadLock or Block but not getting where this may be? FYI this service is a multithreaded application and each thread do the same with different tables.

Dharmendra

You may be running into problems where a given connection is only allowed to be retained for a period of time that is less than the period of time it takes to execute what your trying to execute. Can you have your dot net code call up a stored procedure so that it doesn't have to maintain a conneciton while the process your describe is taking place?

For diagnostic testing can you put "no lock" on all your queries to see if that makes a difference. This can help to determine if it's a deadlock issue.