Monday, February 17, 2014

CDC Logging Reset SQL Code

Use TestDB
GO

Update cdc_logging
set StartDateTime = getdate() - 13, 
    EndDateTime = getdate(), 
    ExtractTime = null 

--select * from dbo.cdc_logging

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.