I am new to CDC and want to know if there is any problem in using CDC. I am targeting to use it for audit purpose i.e. Log activity using CDC and then show th开发者_运维技巧e same to user when needed.
Transactional replication from SQL 2005 into SQL 2008r2.CDC established on SQL 2008r2 side.Each day, from 2 to 4 of these tables lose their CDC settings (ie. is_tracked_by_cdc in sys.tables moves from
SQL Server 2008 has Change Data Capture feature that allows to capture changes made in the ta开发者_运维百科ble, such as insert, delete or update rows.
If I enable change-data-capture for a table, and then som开发者_高级运维ebody else adds a column to the table, will my capture be affected?Will I still get updates for the original columns?For the new
SQL Server CDC(change data capture) is used just for table data chang开发者_StackOverflow中文版e? Can I use it to track procedure or other types of objects change?
I have read that enabling Change Data Capture obviously has an impact on database performance. Would this performance loss only effect the tables that have CDC enabled or would it effect all actions a
Before I open a ticket with Microsoft Support, I thought I\'d try the community! I have an application in development for which we are using Change Data Capture in SQL 2008 R2 (developer edition, cur
I want to run the following rename EXECUTE sp_rename N\'dbo.Semesters.IsPublic\', N\'Tmp_ShowNCs\', \'COLUMN\'
加载中,请稍侯......