November 7, 2007 at 8:55 am
I want to find out the source of a table's data is there a simple way to do this i.e. t1 has fields f1, f2, f3 how do I find out the source for f2 population.
November 7, 2007 at 9:06 am
November 7, 2007 at 9:24 am
How do you do this?
November 7, 2007 at 9:30 am
From enterprise manager click tools and then SQL Profiler from the tools menu. This opens profiler. Click file , new, trace. Select your server and then the trace properties window comes up. On the filter tab set the filters to look at your database and table and run it. It will show all of the activity against the table.
November 9, 2007 at 9:09 am
Forgot to say -- Thanks
November 9, 2007 at 9:16 am
November 9, 2007 at 10:33 am
if f2 is named ell then you can also search sysobjects for distinct names (places) referencing it.
In case some other areas that are not actively being used (which profiler will catch) reference it.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply