Thanks so much. Now, i know why even i still think it is still very confusing by not using the local server time.

What are the data type for those two columns?

Can you also post your "check" statements?

There is no comand of EXEC sp_cdc_enable_db_change_data_capture. Once you execute EXEC sp_cdc_enable_db, then the CDC is enabled for the database and you can verify it by running "SELECT is_cdc_enabled,...

Sorry, I miss read the question. Yes you can do it by changing the custom stored procedure (sp_MSdel_dboTableName) or creating your own custom stored procedure.

Ed

I believe all you need to do is to stop the Log Reader Agent / Distribution Agent. Be careful with Log Reader Agent, if you stop it and the...

I would suggest you to save the data into a table first then utilize sp_send_dbmail for notification purpose.

Ed

Snapshot Replication might no be a good solution. Since it drops all objects and re-create them, I am sure the users will get disconnected somehow. Not only that,...

No. Replication of DDL statements are automatic for ALTER TABLE, ALTER VIEW, ALTER PROCEDURE, ALTER FUNCITON and ALTER TRIGGER.

Excellent article. The way that I have been doing this is to create a report on SSRS and then send the report out in SSIS by calling the Subscription...

I would think Log Shipping might be a better choice. It is easy to configure and maintain. With Transaction Replication, you might need to deal with how to...