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: )

657 reads

Blogs

Daily Coping 5 June 2020

By

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

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

SQL Server Authentication

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

Attunity Oracle Connector Not Showing Up in SSIS Toolbox

By brad.mccollum

I've just about exhausted every effort I can research and absolutely cannot get the...

Covert a string to simple sql datetime format

By Jeff Sims-413169

Can anyone help me out here.  I need to convert strings in a file...

Creating a DB

By Nusc

Hi there, when creating a DB with Auto close= False Auto shrink= True Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers