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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Application connecting to SQL

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 details

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -