Good deal David, I look forward to your comments.

As for you Steve - yeah, all two of us! DMO is most valuable to a VB developer, a good one will...

22g is not bad, I'd say DTS. Just do some testing to figure out the throughput - you'll probably have to adjust batch size to get best results. We'd really...

At least they are consistent - the AnsiPaddingStatus property of the DMO column object is read only.

One workaround would be to use views in place of the tables, trim all...

I tested earlier with SQL login as well. There really is no difference at the sysusers level anyway.

Andy

Yep. Look in BOL under xp_Cmdshell in the TSQL section, item D (in SQL2K). Zero indicates success. Or that there was no return value!

Andy

Its not always just a matter of knowing what you're doing. Often sure, but not always. I get paid to get stuff done. Done right, done fast. If QA can...

I think its one per article. Might have some left over from other replication attempts maybe? Lots of different publications?

Andy

Have not tried it - will try to look tonight if no one has figured out before then!

Andy

You'll get those if you've set up replication for the database.

Andy

Never tried. It's done via trigger, so if nothing else you could log the activity in the subscriber trigger.

Andy

Or use file scripting object, it will let you append to an existing file.

Andy

Dont know if we'll be much help here. You might try one of the C++ newsgroups.

Andy

Never tried it. Dont see why you couldnt manually alter the stored procs it uses to apply the changes to point to another table though.

Andy

Just bad code I think.

Andy

Normally you handle single quotes by doubling them - that is using the replace function to replace any instance of a char(39) with 2 char 39's. Double quotes are ok...