Good morning! I am using TSQL, there is one table that was created years back by another empolyee, I am not sure how this table is populated? I checked the dependencies and it just gives the name of table. I want to know how the columns/data get populated in that table for example. "Freight.load" is the table name. i have ssms 2008 Thank you in advance!
One method I used for a similar problem was to put a shortlived trigger on the table to log the host and user names of anyone writing to that table. You could perhaps also call [dbcc inputbuffer] inside the same trigger, and extract the EventInfo to get the sql commands or procedure name being used. I'm assuming the overhead of introducing a trigger is neglible if you're looking at using profiler, and the table is old and mysterious. :