thanx Fabio,

But my intentions are to know them better. I mean through Vfp and Spt. What does the second Instance do in case of the first having a lock and then lossing the connection midway?
Right. first instance can do nothing but does the sqlserver still hold the lock and still is not avaiable for the second instance?

Can U explain more in detail ?