Solved

Sp_who2

Posted on 2004-09-03
4
760 Views
Last Modified: 2010-05-18
Hi,

Where or How does the  SP_WHO2 gets the information for which program the user is running?

EX:

54  sleeping   NT AUTHORITY\SYSTEM     HOUDB .     msdb     AWAITING COMMAND     31 0     05/14 09:49:55     SQLAgent - Generic refresher                  
55  sleeping   NT AUTHORITY\SYSTEM     HOUDB  .    msdb     AWAITING COMMAND     14420526     09/03 11:26:34          SQLAgent -Alert Engine                      
56  sleeping   ABC_SYS                    SPERRYWS   . ABC_ENERGY18     AWAITING COMMAND     125687 09/02 18:34:08  Gas Modules                                
57 sleeping    ABC_SYS                    SPERRYWS   . ABC_ENERGY18     AWAITING COMMAND     5000 09/02 17:07:30      Financial Bucket    

The one at the very end is programname which i am interested in.

many thanks.
0
Comment
Question by:crishna1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 14

Accepted Solution

by:
Jan_Franek earned 500 total points
ID: 11976075
This info is sent from client at login. It's stored into master.dbo.sysprocesses system table, that is queried by sp_who2
0
 
LVL 34

Expert Comment

by:arbert
ID: 11976528
Agreed--when the application is programmed, you, as the programmer, can change the application name......

if you really wanna see what's going on, run this in query analyzer:

use master
go
sp_helptext sp_who2
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question