Timeout Expired Error
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