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 |
|
R2
Starting Member
1 Post |
 Posted - 2011-09-21 : 00:49:28
|
| HI,I am looking for a way to identify which applications are connecting to my databases. I am running a business that allows clients applications to connect and store data on my databases the problem is that i'm moving a server to a new IP and i don't have an idea which applications uses the database. Can someone tell me if that is possible?Thanks.volon |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-09-21 : 01:36:10
|
| 1) Look at Activity Monitor 2)sp_who2 - 3)Run a Profile Trace and capture the relevant connection detailsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Application connecting to SQL