Friday, July 19, 2013

A small CDC nugget

In the style of Jim Anchower, it's been a long time since I rapped at ya. Life's been busy, but that's little excuse, eh?

I recently read an article on SQL Server Central here that gives a very decent overview of CDC processing. One thing that I pulled out was an undocumented stored procedure called  sys.sp_cdc_dbsnapshotLSN that will, as the name suggests, give you the LSN of a database snapshot. Pretty useful stuff if you need to re-initialize your warehouse!