Change Data Captures
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server. I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......? i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise. I’m kinda new to this i did this in sql 2005 and the data is being updated fine in the _CDC tables. so please help in this reporting part. So could you please tell me all that I need to do. Any code given would be a real help Thanks
October 26th, 2010 5:49pm

Hi justin, Since you have created some user tables to record these changes, you could write the T-SQL query as the report dataset, then show them on your report. On the report, you can do some aggregation or indicator for the report purpose. See http://msdn.microsoft.com/en-us/library/ms170246(SQL.90).aspx for some information of Reporting Services Tutorials if you just start to use reporting services. If you want further support, please ask the detailed question about creating your report. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2010 11:01pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics