Thanks abdul,

Yes..It seems to solve my problem.

Actually i am not a db person, but I learned a lot from your mail.

I have one more doubt.

We are trying to lock...

No body is there to help me further ?

Thanks for your help ijaz.......

But It won't work, because we should not keep sp_password within a transaction like begin,commit,rollback.....it will fail

and it's giving error as.....The procedure sp_password cannot be executed...