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 |
learntsql
524 Posts |
Posted - 2009-11-11 : 07:09:45
|
Hi...When everyone is loging as SA acountIs there any way to find Original login/Machine IP/Namefrom the server machine.All machines are connected in LAN. |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-11-11 : 08:12:59
|
select host_name() KH[spoiler]Time is always against us[/spoiler] |
|
|
learntsql
524 Posts |
Posted - 2009-11-11 : 08:17:35
|
It gives the localhost name.but i want to find all client machine names who are connected to this server.Is it possible? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-11-11 : 08:20:18
|
exec sp_who KH[spoiler]Time is always against us[/spoiler] |
|
|
learntsql
524 Posts |
Posted - 2009-11-11 : 08:25:37
|
Its giving only login name as SA,If all users login with sQL server authenticatin will ramain same for all users. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-11-11 : 08:29:37
|
sp_who will give you loginname & hostname. isn't this what you want ? KH[spoiler]Time is always against us[/spoiler] |
|
|
learntsql
524 Posts |
Posted - 2009-11-11 : 23:57:26
|
Sorry. the same i wanted.I have one more query when i see the SQL built in reports like "Schema Changes History" Its Only Showing login name as "SA"Can I able to see HostName/Machine Name from where the Objects have been modified. |
|
|
|
|
|