Tag Info

New answers tagged

1

It appears that this was added in the 2008 time period. You can see the Connect item with the title "MSIT-MSO: Use NOLOCK while querying the cdc._CT table in CDC TVF" at: http://connect.microsoft.com/SQLServer/feedback/details/331486/msit-mso-use-nolock-while-querying-the-cdc-captureinstance-ct-table-in-cdc-tvf It is interesting that the request was made ...


3

For which tasks/scenarios is CDC the right tool? (e.g. Allowing users to restore a data object to a certain point in time? Maybe, it depends. Auditing? Yes. Showing the complete history of data?) Yes. When should you rather not use CDC, but resort to a custom trigger-based solution? When the data in the change table does not meet ...


6

Firstly, Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server. So that may decide for you if any of your customers will not have the enterprise editions, or you don't yet know you will be using the enterprise editions. (As the spec includes "multiple future applications" this may be an real issue ...


1

Here is a very well written 9 part series that reviews the different ways of auditing SQL Server data changes. Parts 3, 4 & 5 focus on CDC. It's worth reading through all of the articles because this will answer your questions, like the different scenarios where the features would be appropriate and overhead. ...


2

CDC relies on a SQL Server Agent job to capture information from the transaction log. You can customize the job parameters by updating msdb.dbo.cdc_jobs - there are multiple properties as described in this Books Online topic: maxtrans maxscans continuous pollinginterval That doc has some information about these parameters, as does this white paper. But ...


1

Input (hopefully stored procedure parameters): DECLARE @table1 NVARCHAR(513) = N'dbo.Users', @table2 NVARCHAR(513) = N'dbo.DataObjects', @ID INT = 10; Code: DECLARE @InstanceName1 NVARCHAR(513), @InstanceName2 NVARCHAR(513), @Begin_LSN BINARY(10), @End_LSN BINARY(10); SELECT @InstanceName1 = ...



Top 50 recent answers are included