Thanks Grasshopper for the reply.

but my question is is it advicerble to set the SET TRANSACTION ISOLATION LEVEL SNAPSHOT in the calling SP ?

I am in Sri Lanka, Can I appli for this job or this is only for LA