Script To Show Which Tables Are Changed

The following T-SQL query batch will show you which tables was changed since last execute. Tracking information: (1) changes row count /insert,update,delete/; (2) changes IDENTITY value; (3) changes physical allocations /used pages/; (4) added new tables; (5) dropped tables. The batch must be initialized before using (at least once executed). I use this batch to […]

5 (1)

2006-06-12 (first published: )

661 reads

Blogs

Removing a Deleted Column from a Data Masker Masking Set

By

Data Masker for SQL Server is a great tool ensuring the data you use...

Containers: A Short Rant

By

I find myself doing more and more work with containers. Yet, I also find...

Daily Coping 20 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Metadata-Data-Ratio in a table

By sean redmond

Hi all, My understanding about the structure of data within SQL Server is that...

Always On - why No failover occurred?

By onlo

Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...

Log Shipping Truncate Log File

By coolchaitu

Good Morning, I have read that taking a log backup truncates the log file....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers