Hi all, Can someone help me out 1

[goofy]

Hi all,

Can someone help me out on how to differentiate between a system process or a user process in sql server

Thanks

 

[ClaireHCM]

I am not sure whether this is what oyu are looking for.

use master

select loginame,spid from sysprocesses where spid <=50 is system process
select loginame,spid from sysprocesses where spid >=51 is
user process

 

[goofy]

Hi

&quot;SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>&quot;

What is the possibility of getting a SPID 5 (which is a task manager - system process) while using a query specified above. Provided a database id is specified in the where clause

I used a above specified query with in a stored procedure and the SPID returned was 5

Thanks