Replication Question Can I find IDs of updated rows only? 1

[checkai]

I have two databases. A production and a reporting db. The reporting db gets a transactional snapshot applied to it nightly for many tables.

An example is tblWIP.
Is it possible to pull the wipIDs that were updated by that snapshot and put them into a db table or access them in some way?

Thanks!

 

[checkai]

Would it be possible to have a trigger on the table that I want all of the IDs for?

So when the transactional replication for tblWIP was applied, I could have a trigger on Insert/Update/Delete to hold all of the affected wipIDs?

 

[mrdenny]

As you are using Transaction Replication, yes you can setup a trigger on the subscriber and then pull the IDs which are being added/updated via the inserted virtual table.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog