Sorry could not post the code, because I only get one line to type in and I can't paste in either. Hope my question is clear without the example.

Should I be writing the Select statement in a different way to improve performance?

I have been using ADO for some time against procedures and am not aware of any other method for updating. All my ADO is based on the examples in Microsoft...

Thanks for the replies, the code above is exactly what I was looking for. Great!

I used the wizards to migrate and was caught out many times by the many small pitfalls. With hindsight, I think I might have been better off if I had...

Thanks for the further replies. I will explore these further.

dam432, I did not need a user id - The guys in charge of our internal SMTP relay gave access rights...

I searched for cdosys on this site and tried the scripts I found but none worked. I either got error messages or they worked but nothing happened.

However searching using cdosys...

But the strange thing is that in the same column it imported some integers but not others. The only text in the column was the column header. Otherwise just nulls.

In...

My subscription has not been working ever since I changed my email address

Doesn't ntext takes twice as much space as text?

quote:

---

quote:

--------------------------------------------------------------------------------

The Unicode specification defines a single encoding scheme for most characters widely used...

Corey, that's amazing. Did you find this documented anywhere. I would like to explore this further.

Regards

Stefan

Problem solved - I have been able to repeatedly test disaster recovery - Just found it amazing how many hurdles I had to overcome and document in the learning process.

...

Thanks - have installed and now see the updated sp3 - You would think MS would have an option in BOL help which told you this.

quote:

---

Do you need the blank row for the formatting? Can't you apply the formatting to the title row?

---

December 1, 2003 at 9:10 am