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 |
|
mateenmohd
Constraint Violating Yak Guru
297 Posts |
 Posted - 2007-03-11 : 01:51:33
|
| 1. How can get Server IP Address and user login id by sql query analyzer ?2. we have two servers. my sql server connected with another server. I want to known about that how many users are connected with our Sql Server and what it login id.3. How can get the IP address and login id of other sever with is connected with my sql server ?i.e.my SERVER name is auhtripdcother server name is tripI want to know about above both server ip address and how many users accessing above two server ?thanks and regardsMateen |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-11 : 05:13:45
|
| SELECT SUSER_SNAME(), HOST_NAME()Peter LarssonHelsingborg, Sweden |
 |
|
|
mateenmohd
Constraint Violating Yak Guru
297 Posts |
Posted - 2007-03-11 : 07:25:33
|
| Thanks for response.there is any procedure / trigger to get server ip address?Mateen |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-11 : 10:11:19
|
| Tracert, ping.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Server IP Adress / accessing user