How do I locate the IP Address of a machine running BCP?

We have an unknown machine that has a BCP scheduled every night against a table. Is there any way to locate the IP address of the machine that is running the BCP?
fsoehngeAsked:
Who is Participating?
 
YveauCommented:
start a trace in the profiler:
Start - Programs - Microsoft SQL Server 2005 - Performance tools - SQL Server Profiler

start a new trace, based on the 'blank' template. Then in the evnt selectoin tab, choose the 'audit login' from the 'audit security' events. From there you can retrieve the hostname of any connection made to your SQL Server while the trace was running.

Hope this helps ...
0
 
fsoehngeAuthor Commented:
That worked great! Thank you.
0
 
YveauCommented:
Glad I could be of any helps and thanks for the grade !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.