Avoid using INSERT INTO EXEC because this can trigger locking the tempdb.

Check this out

http://www.sql-server-performance.com/reducing_locks.asp

Thanks,

Abhinav

That didn't help either

Any other ideas....plzzz

Thanks,

Abhinav

Based on the Profiler, the SP2 is not being recompiled. So, using the KEEP PLAN option did not help either

Here is the...

No table is getting locked. The Stored Procedure is being locked down. Based on a query joining syslocks and sysprocesses I can see that the exclusive locks are placed on...

That didn't help

The SP2 is being locked when it is being executed from SP1. The Locks are released as soon as it completes...