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 |
|
swordfish
Starting Member
11 Posts |
 Posted - 2003-03-06 : 10:55:22
|
| I have a SQL 2000 database which is accessed by an ASP web app, a VB desktop app and manually through Query Analyser. I would like to be able to tell application is running a particular query. I have tried using SQL Profiler, but I can't find how to do this. Do I need to use PerfMon or another tool? All the applications use the same login to access the database.Thanks in advance for your help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-06 : 11:20:10
|
| sp_who2 has a column called "Program Name" that indicates which app is running on that connection. |
 |
|
|
swordfish
Starting Member
11 Posts |
Posted - 2003-03-06 : 11:35:10
|
| Brilliant, thats exactly what I'm after!Thanks a lot! |
|
|
|
|
|
|
How to tell what application runs a query?