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

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

Determine IP of Client Adding Record to SQL Database Table

I have a Microsoft SQL 2008 Standard Server with a database for a 3rd party application. One of my client computers is repeatedly creating a record in a specific table and I need to know which client computer (by IP preferably) is creating that record. Is it posible and if so how do I track the IP of the computer creating records in that table?
0
callworth
Asked:
callworth
1 Solution
 
SterlingMcClungCommented:
My first thought would be to use a trigger on that table, looking for the specific record and log that outputs the required information to a separate table that you can check periodically.
<links removed - GaryC123>

The ability to do this is going to depend on the database that you are using and if there are existing triggers on that table already.  I'm not sure if this is the best solution, but it was the first that came to my mind.
0
 
guswebbCommented:
Right-click the server name in SSMS and open Activity Monitor. You might just see the offending system (and SQL login being used) in there if it is repeatedly making connections and inserting rows. You can right-click individual processes and view the details of the query being executed to find the query you are looking for. Worth a look!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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