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.
| Author |
Topic |
|
jeffma
Starting Member
2 Posts |
 Posted - 2006-12-20 : 21:46:09
|
| select * from sysprocessesHow can I determine whether a process a system or user? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-20 : 22:05:43
|
| loginname? |
 |
|
|
jeffma
Starting Member
2 Posts |
Posted - 2006-12-20 : 22:14:38
|
| I want to count the client process. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-21 : 17:27:32
|
| Doesn't sysprocesses give you enough info to do this? It gives you the login name and the app name. Presumably you can do an aggregate based on this. |
|
|
|
|
|
|
System process or user process