sql statement

Last Post 20 Sep 2006 11:56 AM by sqlpool. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sqlpool
New Member
New Member

--
19 Sep 2006 05:54 PM
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
sqlpool
New Member
New Member

--
20 Sep 2006 08:15 AM
So how can I limit sql to run on specific cpu? sp_configure can do the trick?

Thanks rm.
sqlpool
New Member
New Member

--
20 Sep 2006 11:56 AM
cool. thanks.
You are not authorized to post a reply.

Acceptable Use Policy