开发者

Get the inserts

开发者 https://www.devze.com 2022-12-24 04:10 出处:网络
I want to know if I can get all the INSERTs that are inserted at my database, from once. Writing just once ... I want that shows me all t开发者_如何学编程he inserts with the data and everything that

I want to know if I can get all the INSERTs that are inserted at my database, from once. Writing just once ... I want that shows me all t开发者_如何学编程he inserts with the data and everything that was inserted in the moment of insertion. Not just the data, but everything including the INSERTs, is this possible?

I'm using SQL server 2008.


I can only think of two methods:

1) You could try using the new auditing features of SQL Server 2008 How to: Create a Server Audit and Database Audit Specification

2) write an INSERT trigger for each table and send the INSERTED table to a common log.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号