Hi
"SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>"
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
"SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>"
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