My little trick is to select detach database in the GUI. It will tell you there are active connections and do you want to kill them ?  I say yes,...

Yes, I think it will roll them all back. Better to run it as a job ... it's faster than running it interactively from your session.  Also, for the 20,000,000...

That's a strange one !

I usually just remove a specific table, change it, then add it back in, and leave the rest of the publication alone.  (Doesn't explain your problem,...

You must have primary keys for transactional. Without keys, you can use snapshot, but that pushes the whole table each time. Can you add primary key fields at the end...

I'm pretty sure it's a non-issue. We went from SP3 to SP4 a while back, and I think it took all of 5 minutes. I would remember if it affected...

EDIT: I just realized I posted this to a 2 1/2 year old thread !!   Sunny, Why did you bother dredging this up ??

"...The problem is that the database which...

If you post this in the SQL 2005 forum you may get better results.

So, your database is CollationA, but the columns Are CollationB ?  How did the collation get wrong...

"... What about 2007-04-01 is it yyyy-mm-dd or yyyy-dd-mm ? ..."

Does anyone actually use YYYY-DD-MM  ??  Defeats the purpose of having YYYY first

" ... Only the International (yyyy-mm-dd) is self-describing and explicit. So it would be cool if you would use it. ... "

I agree .... 

"... You need to enable mail profile in sql agent properties..."

That was it !   I had everything else setup, didn't realize I had to enable it as well ....  then...

Thanks for the help !  

Clarification: We WERE getting the errors in SQL2000 as well, I just hadn't heard about them because of all the other problems we were having with other things.

Are there any implications...

" ... 1. For each table, insert the data, to be deleted, into a corresponding "purged" table, to remain there for one day only. ..."

In this step, your "purged" table...

We do something similar when we do large updates or purges. We store them in another DB that is simple recovery, rather than clutter up production.

Maddogs ....  Yes, I'm a homebrewer, although I haven't done much lately.  We have a good homebrew club here in SW Connecticut.  I switched to full mash & good yeast...