Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication and Trigger

Status
Not open for further replies.
checkai

checkai

Programmer
Jan 17, 2003
1,629
US
We have Transactional Replication pushing data to our Reporting Database once a day.

I am thinking of putting a trigger on one of the tables that gets hit by the replication. WHat the trigger would do would be to insert the ID of the table into another table. Basically, showing me all the IDs that were affected by the replication that evening.

If my table is getting 50,000 records inserted an evening, is that trigger a bad idea?

Thanks for any input on the topic!
 
Status
Not open for further replies.

Similar threads

DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
162
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question
Delphi/Borland program and SQL Express 2017
Replies
6
Views
298
JoPaBC
JoPaBC
JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
310
JoPaBC
JoPaBC
tekpr00
  • Locked
  • Question
Backups in a multiserver environment while using Central Management Server and Server Groups
Replies
0
Views
99
tekpr00
tekpr00
tekpr00
  • Locked
  • Question
Capture and Replicate Changes from Source to Target.
Replies
0
Views
69
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top