GilaMonster (8/2/2014)
Also need to keep in mind that CDC is Enterprise Only.p.s. Nolock has side effects, it's not a go-faster switch that should be added to every single statement. Let's not teach people bad habits.
Further on Gail's comment on nolock, according to MSDN: For UPDATE or DELETE statements: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
😎