identify the application server which connects to the sql database.

Hello,

We have a legacy application server which connects to a sql database.  We plan to decommission this database but have trouble to identify the server which runs the application.  

Is there a way I can search from the database to identify which system connects to the database?

Thanks
nav2567Asked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
Or you could simply use SQL 2005 SSMS "Activity Monitor" under Management to do that:

http://msdn.microsoft.com/en-us/library/ms175518(v=sql.90).aspx
0
 
AnujConnect With a Mentor SQL Server DBACommented:
Use SQL Server Profiler, or sp_who2 and check the column hostname for the details.
0
 
nav2567Author Commented:
thanks.
0
All Courses

From novice to tech pro — start learning today.