Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Background processes

Author  Topic 

susheel
Starting Member

1 Post

Posted - 2008-01-24 : 07:34:43
Hi all,

Can anybody tell me what are the background processes running in sqlserver databases.


regards
Susheel

agapimu6969
Starting Member

9 Posts

Posted - 2008-01-24 : 10:03:47
You can try this function sp_who2
Go to Top of Page

CShaw
Yak Posting Veteran

65 Posts

Posted - 2008-01-25 : 01:16:00
I you post the results and the connections that you may not know I am sure someone can help you. The reason this is so vague is because there are a number of them in there.

Chris Shaw
www.SQLonCall.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-25 : 23:35:49
All processes with spid <= 50 are system process.
Go to Top of Page
   

- Advertisement -