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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2007-09-07 : 11:06:15
|
| We are trying to determine what servers are connecting to our production sql server box and I'm looking at running the sql server profiler to show this. Is it possible to show from what server the connection is being made?thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-07 : 11:14:21
|
| > what serversas in linked servers?or do you mean users?profiler has a Security Audit -> Audit Login event that holds the incoming connections info_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
SQL Profiler (where logins are comming from)