How to find a running application in SQL Server?

How to find a running application in SQL Server?

Hi

In SQL Server (7.0, 2000), we know HOST_NAME() in a DEFAULT definition is used to record the workstation name of computers. But I need to find the name of the application which interacts my DB from the workstations. Is it possible? Please help me

Regards

Ahmed Sahib

ibnukuraish@.gmail.com

Hi Ahmed,

You can get this info from the following:

Code Snippet

Select * from master..sysprocesses

--or

SP_WHO2

Jag

|||

The equivalent to the host_name function for the application name is the app_name() function. The application name may or may not be set - it depends on the connection properties used by the application.

-Sue