Technical Article

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)

You rated this post out of 5. Change rating

2006-06-12 (first published: )

715 reads

Blogs

THAT Conference 2024 in Wisconsin Dells

By

I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...

7 Best Online Advanced SQL Training Courses to Learn in 2024

By

The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Read the latest Blogs

Forums

Thinking About Technology

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thinking About Technology

SQL Server on Linux Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server on Linux Restrictions

Error fetching data via Linked Server

By Ram

Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers