[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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?
0
fsoehnge
Asked:
fsoehnge
  • 2
1 Solution
 
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now