In a word no. The account you login as does not
affect the spid/thread priority if that's what your
question is about :-) You can't set thread priority
using inbuilt sql functionality however there is some
discussion of this in Ken Hendersons excellent
Guru's Guide to SQL Server Stored Procedures,
XML, and HTML and he has an extended stored
procedure that can be used to adjust thread priority
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
> SQL Server 7.0 SP4 with NT 4
> Some of our developpers (and some end users) work with very privileged
> with Server Roles : System Administrator, etc....
> and Database Roles : db_owner, etc....
> Most of our end users work with very low privileged account
> with only Database Roles : public
> My question is:
> Does SQL Server is going to execute tasks of very privileged account
> the tasks of low privileged account ? If yes, how can "see" it ? via
> Profiler ?
> Thank you