I have a stored procedure as follow:
insert into callbook
(
callsrno,calldate,customerid,product,modelid,srnumber
,purdate,warranty,dealerid,complaint,enqtype,callfrom
,prefdate,preftime,callstatus,ipaddr1,userid
)
values
(
convert(nvarchar(11),@callsrno),@calldate ,@customerid ,@product ,@modelid ,@srnumber ,
@purdate,@warranty ,@dealerid ,@complaint,@enqtype ,@callfrom ,
@prefdate,@preftime ,@callstatus ,@ipaddr1 ,@userid
)
But some time more than one user accessed this sp.
and ambiguous record saved in my database.
So I want to restrict simultaneous access of SP.
Thnx...