Hello all,
We made a program that syncronize 2 db over the net, for that we build a
WebService that sits at the server that one of the dbs is sitting (SQL), now
every time that the WS is running a SELECT query and get the results after i
dispose the WS, a proccess of the WS is still active on the Proccesses of
the SQL, as you can imaging after 10 minutes of asking the WS (every 30sec)
and dispose it each time the proccesses in the SQL are so many that the WS
is time-out, do anybody knows a way to overcome this???
Thnx in advance
Nassos