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 |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2003-02-06 : 09:06:52
|
| Salute...I have SQL 2K and VB.NET environment.I use the following query to check for current connections:SELECT loginame,program_name,hostname,nt_username FROM master..sysprocesses WHERE len(hostname) <> 0In the resultset I get ".Net SqlClient Data Provider" for every .NET application connected to the server. The questions IS : How can I see the REAL ( for example General Ledger) instead of the .NET sql data provider name?Thanks In Advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-06 : 09:15:40
|
| You'd probably have to pass it in the app's connection string, but I don't know what the value might be. In ODBC I believe something like "APP=General Ledger;" would've been the proper format. If that doesn't work, you'd need to find a reference for the data provider you use. |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2003-02-06 : 10:15:22
|
| Thanks .. It worked FINE! |
|
|
|
|
|
|
program_name in sysprocesses