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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-04-18 : 20:23:16
|
| I have users logged in 3-tier and running processes on server. I cannot tell who is doing what because they all have same access id 'sa' to the database.This is because they loginto PeopleSoft DB on SQL Server via Application Server (Tuxedo).When they login two tier, I can get their information but not in 3-tier.Anyone know of this situation? Note: I posted this issue on PeopleSoft forums too but I didn't get any feedback.Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-18 : 20:47:07
|
| You can try using the HOST_NAME() function, or checking the "hostname" column from the "sp_who" system procedure. This is usually the name of the computer that is connected to the SQL Server (although it can be overidden, you may need to contact Peoplesoft about it) There is also the HOST_ID() function, but I don't know how helpful it will be because it won't necessarily tell you the name of the user. You will probably be better off running sp_who or sp_who2 and putting the results into a table. If you can't change the logins, you can change the workstation names to match the name of the people using them, or compile a table listing the computer names and associated users.Shit, now that I think about it, it sounds like Tuxedo or Peoplesoft will handle all the connections to SQL Server, and HOST_NAME/sp_who won't work either, unless by some miracle the software passes that information along, but it's unlikely.Edited by - robvolk on 04/18/2002 20:59:50 |
 |
|
|
|
|
|
How to watch jobs on SQL Server in 3-Tier?