Change Data Capture (CDC) is great new technology available in SQL 2008, and I highly recommend looking into it for those of you who need to track changes to tables. However, when enabling CDC, make sure you create the CDC role first. If you run the stored
Read More