<div>
You can get information when is the last time table was updated, when it was created , when it was used etc..<br />
<br />
other than that I think this is not possible with any auditing mechanism. <br />
<br />
<b>You should try out Change Data Capture , Change Tracking or some other custom tracking method.</b><br />
<br />
Hope it helps !!
</div>


You can get information when is the last time table was updated, when it was created , when it was used etc..

other than that I think this is not possible with any auditing mechanism.

You should try out Change Data Capture , Change Tracking or some other custom tracking method.

Hope it helps !!

<div>
Do you have any good query to pull this information?
</div>


Do you have any good query to pull this information?

<div>
No there is no query for these. You have to enable these things. For example Change data capture.<br />
<br />
Refer links for step by step info. &lt;&lt;CDC &nbsp;- Change Data Capture&gt;&gt;<br />
<br />
<a href="https://msdn.microsoft.com/en-IN/library/cc627369.aspx" rel="ugc">https://msdn.microsoft.com/en-IN/library/cc627369.aspx</a><br />
<a href="http://sqlmag.com/sql-server-2012/tracking-changes-sql-server-2012" rel="ugc">http://sqlmag.com/sql-server-2012/tracking-changes-sql-server-2012</a><br />
<br />
Hope it helps !!
</div>


No there is no query for these. You have to enable these things. For example Change data capture.

Refer links for step by step info. <<CDC  - Change Data Capture>>

https://msdn.microsoft.com/en-IN/library/cc627369.aspx [https://msdn.microsoft.com/en-IN/library/cc627369.aspx]
http://sqlmag.com/sql-server-2012/tracking-changes-sql-server-2012 [http://sqlmag.com/sql-server-2012/tracking-changes-sql-server-2012]

Hope it helps !!

<div>
What's an 'intek', and what exactly do you mean by 'How to generate Total data intek per day'?
</div>


What's an 'intek', and what exactly do you mean by 'How to generate Total data intek per day'?

<div>
What I am looking for is to compare &nbsp;data size between day 1 to day 2,<br />
<br />
I believe this will give me &nbsp;some rough estimate of how much data was entered into do.
</div>


What I am looking for is to compare  data size between day 1 to day 2,

I believe this will give me  some rough estimate of how much data was entered into do.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
<br />
How to generate Total data intek per day for individual DB?<br />
<br />
Is there any SQL queries I can run against DB to generate this info?<br />
<br />
Regards, m
</div>
</div>


Hi


How to generate Total data intek per day for individual DB?

Is there any SQL queries I can run against DB to generate this info?

Regards, m

How to generate Total data intek per day for individual DB

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.