Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stain2319
Starting Member
1 Post |
 Posted - 2013-08-23 : 08:11:44
|
| Let's suppose you have an MSSQL database. (2008 Enterprise R2). And let's say you have about 10 different processes running in an environment on different servers which can all access this database and insert data. And let's say that all 10 of these processes may even insert data into the same table at different times. And let's say that one of these processes seems to be inserting some erroneous data - specifically a value of "0" in a row where non-zero values are always expected. And let's say it's a production environment where none of these processes can be disabled for testing - and let's also say that there could be some other 'rogue' process you're unaware of which might be inserting this data. Is there any way to monitor and find out exactly which process inserted the specific piece of data? Or a way to "watch" inserts, and when a specific process tries to insert a 0 into a specific table, have that logged somehow?I know that through Activity Monitor I can see the different processes in real time and what they're doing, what I am looking for is some way to 'alert' me when "some process" inserts the zero value to a table, and let me know what process did it, so I can identify which of my 10 processes has a problem (or whether it is an 11th rogue process). |
|
|
|
|
|
identify what process is responsible for inserts?