Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT).
We made the decision to run it in Simple mode, but I had left it in Bulk-logging while I tried to find a pattern. I knew that there were some other things that may need to be pulled into a Trans log backup when the DB is in Bulk logging, but I would have never […]
I have SQL 2000 installed and am having problems with the Full-Text search. I am able to create a new catalog, but when I try to populate it, the job completes immediately and no records are indexed. In my event log I receive the following error "The crawl seed <MSSQL75://SQLServer/6e565ce8> in project <SQLServer SQL0001300005> cannot […]