Thanks guys,

What we trying to do is give certain sp's priority over others.

The sp's could be accessing the same tables.

But some have a higher importance with regards to...