Lowering priority

Is it possible to execute a SP at a lower priority?What do you mean?
"Mohandas" <mohanaspm@.hotmail.com> wrote in message
news:#ZxF6EYuDHA.1088@.tk2msftngp13.phx.gbl...
> Is it possible to execute a SP at a lower priority?
>|||I'm afraid not. You cannot specify priority at procedure, connection or any level inside SQL Server.
There's something called SET DEADLOCK_PRIORITY LOW, but this is a special situation.
Also, you could do dirty reads, but that can of course return incorrect information.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mohandas" <mohanaspm@.hotmail.com> wrote in message news:%23ZxF6EYuDHA.1088@.tk2msftngp13.phx.gbl...
> Is it possible to execute a SP at a lower priority?
>