Mr Strange

I appreciate the information but it also would be helpful to list title/ISBN of Itzik Ben Gan book that you are referring to.

Thank you for the article. I would like to know how to capture 'TRUNCATE TABLE' command. The reason I am asking this is DROP CREATE ALTER event can also be...

My advice:

1) on destination table never use char or varchar. Instead use Unicode nvarchar or nchar

2) do not copy data directly from flat files source or excel file source to...

Why drop and create tables, shouldn't 'truncate' command do the same thing with less overhead?

Excerpts from this article:

"It doesn't make sense to maintain one set of indexes for all copies of the database. Each database needs its own."

I completely disagree with this statement....