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?
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
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…