Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL Server – Error While Enabling CDC on a Table – The specified ‘@server’ is invalid (valid values are returned by sp_helpserver)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CDC
Every environment is different and it is no doubt some of these environment changes can give you results that are not expected. Recently one of my blog reader followed below blogs: SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008 SQL SERVER – Download Script of…
Read More

SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
CDC, Database, MVP, SQL Index, SQL User Group, SQLAuthority Author Visit
TechEd Sri Lanka was held at Waters Edge, Colombo between Feb 8 and Feb 10, 2010. It was one of the largest successful technical event in Sri Lanka. I was extremely surprised to how technically sound this event was and how excited the TechEd attendees were. I presented there on…
Read More

SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CDC, SQL Error Messages, SQL Scripts, SQLAuthority Author Visit
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here: SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore. I mentioned during the session that CDC is asynchronous and it reads the log file to populate its data.…
Read More

SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008

Pinal Dave
SQL Tips and Tricks
CDC, Database, SQL Data Storage, SQL Scripts, SQL Server, SQL Utility

Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced in SQL Server 2008. Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change tables’ rather than in an esoteric chopped salad of XML. These change tables contain columns that reflect the column structure of the source table you have chosen to track, along with the metadata needed to understand the changes that have been made.

Read More