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!
No comments:
Post a Comment