InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:32:07 GMT20http://www.sqlservercentral.com/Forums/Topic1381077-391-1.aspxThanksThis is Awesome, help me a lot.Mon, 05 Nov 2012 10:39:11 GMTsurma.sqlhttp://www.sqlservercentral.com/Forums/Topic1381077-391-1.aspxSomething like the following would work[code="sql"]create table tablemonitor (name sysname, rows bigint, reserved varchar(100), data varchar(100), index_size varchar(100), unused varchar(100), datecollected datetime default getdate())insert into tablemonitor (name, rows, reserved,data,index_size,unused) exec sp_msforeachtable 'sp_spaceused [?]'[/code]Wrap the insert into a SQL job to execute daily, then you can query the table and see which tables are growing day by day.Mon, 05 Nov 2012 07:30:25 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381077-391-1.aspxHi,you could use the script @:[url]http://blogs.technet.com/b/mdegre/archive/2009/10/14/determining-sql-server-table-size.aspx[/url]Ensure that the data is stored in a persistent table instead of a #temp table.Then you can also setup a SQL job to run the stored procedure at a set interval, e.g. every morning, which will append tot he table (add a date column to the table). And finally you could create a small SSRS report against that table to view how the table(s) are growing over time.HTH,BMon, 05 Nov 2012 07:30:20 GMTbleroyhttp://www.sqlservercentral.com/Forums/Topic1381077-391-1.aspxHelloI need to Monitor which table growing for Database.so please help me to do this.I have no idea how to monitor growth of the tables.ThanksMon, 05 Nov 2012 07:23:12 GMTyogi123