1. Which SQL statment can find out the status of the store procedure? For example, I want use SQL command to check if the store procedure is running or not instead of using SQL profiler.
2. If my server has 4 cpu, I want to force sql query to use two of them. Which sql statement can do that?
Thanks in advance