Hi Aaron,

Thanks for the reply, the solution you have suggested seems convincing at first glance but the problem is that client will never know that connection is terminated by the SQL "KILL"...

quote:

---

Hello David,

Thanx 4 ur reply. Yes UPDLOCK has the advantage...

quote:

---

Hello Steve,

Thanx for your reply. Yes u r right that

i m trying to use a flag to...

quote:

---

I know sir, but i did'nt post it explicitly it was mistakenly posted twice. Sorry for inconvenience.

Please do not post a question...