Hi Group,
I am facing a problem regarding locking. I have created a Stored
Procedure in my Database. In this Stored Procedure Temprary Tables get
created and after that values are inserted in these tables.But this
Stored Procedure is called from Java Portal. When then Stored Procedure
execute from Java end new transaction begins. So all these temporary
tables are created in tempDB and locking the entire Database.
So at the same time if another user fires the same Stored Procedure
from portal end its give the error "Lock time out". But if the prev
Stored Procedure execution gets competed before this request then no
error comes.
So is there any way from database to restrict to lock the tempDB
database????
Can you provide some valuable advice?
Thanks in advance.
Regards
Arijit Chatterjee