<div>
<a href="http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step" rel="ugc">Run a trace in SQL Server Profiler</a>, you will find the details.
</div>


Run a trace in SQL Server Profiler [http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step], you will find the details.

<div>
Simplest way is perhaps to create the trigger on insert and capture some information there (login name, app name, etc).<br />
<br />
SQL profiler would work too if you want to parse TextData for sql statements.<br />
<br />
There are other ways, of course, extended events, audit, etc but trigger perhaps is the simplest. Just don't forget to drop it when you are done
</div>


Simplest way is perhaps to create the trigger on insert and capture some information there (login name, app name, etc).

SQL profiler would work too if you want to parse TextData for sql statements.

There are other ways, of course, extended events, audit, etc but trigger perhaps is the simplest. Just don't forget to drop it when you are done

<div>
Thanks for the suggestions. &nbsp;I looked into the trace but i am not a DBS so it seems pretty intimidating.<br />
<br />
The idea of a trigger I understand but I have no idea what info should be captured or where that info resides.<br />
<br />
Hints?<br />
<br />
thanks.
</div>


Thanks for the suggestions.  I looked into the trace but i am not a DBS so it seems pretty intimidating.

The idea of a trigger I understand but I have no idea what info should be captured or where that info resides.

Hints?

thanks.

<div>
Close this question. &nbsp;I will have to hire a local dba to get the solution because I can not personally carry out their suggestions.
</div>


Close this question.  I will have to hire a local dba to get the solution because I can not personally carry out their suggestions.

<div>
<div class="content wysiwyg-content">
I have to find how a user table is being filled. &nbsp;The table is used in a dashboard but we cannot identify when or how it is being updated, we just know that it is. &nbsp;The only stored procedure that references the table just reads it. &nbsp;No SQL job I can find writes to it.<br />
<br />
I have renamed the table and am waiting to see if anything breaks but this seems drastic. &nbsp;There has to be a better way.<br />
<br />
Does anyone have any ideas?
</div>
</div>


I have to find how a user table is being filled.  The table is used in a dashboard but we cannot identify when or how it is being updated, we just know that it is.  The only stored procedure that references the table just reads it.  No SQL job I can find writes to it.

I have renamed the table and am waiting to see if anything breaks but this seems drastic.  There has to be a better way.

Does anyone have any ideas?

Who is filling a SQL table?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.