hi sql experts, I run a financial application. There is a stored procedure which calculates commission and consists of many queries and sub-queries. When i run this procedure I am not able to run other sp while commission sp is running. Can anyone help me what could be the issue here. Thanks in advance.