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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-07-06 : 05:07:51
|
| Dear all,In the production server i have a table near to 2 lacks records in that.From one or other way i need to find out the source which is making this table to update everyday.I have a column on this table "datemodified" from that i could notice that all the record are getting updated by some other program/Job.I want to know which stored proc/or job/username etc which is getting updated this table.Some kind of triggers or profiler guidance will be helpful.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-06 : 06:14:54
|
| It can be easily done using a SQL profiler.Columns ApplicationName and TextData will give you the necessary information.PBUH |
 |
|
|
obiron
Starting Member
23 Posts |
Posted - 2011-07-06 : 08:04:52
|
| You could search sysobjects for references to the table. Can't remember off hand which field it is but there are plenty of examples on the web. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-06 : 09:09:57
|
quote:
Originally posted by obiron
You could search sysobjects for references to the table. Can't remember off hand which field it is but there are plenty of examples on the web.
So how are you going to monitor that ?PBUH |
|
|
|
|
|
|
Mass update to a table