I have created two SPs. Both independently work fine. when I execute one store procedure from another one, it takes time and gives me timeout error.
what could be possible issue?
I guess it will be locking: