Thanks for the feedback... and the pretzel!:P

rbarryyoung (8/28/2008)

---

Jeff Moden (8/28/2008)

---

It's also part of the reason I wrote that forum ettiquette article on how to provide actual test data so that good folks like yourself don't...

thomas.lemesurier (8/28/2008)

---

Hmmm, Lowell hit the nail on the head - it's a unicode file. But having said that, I've tried saving it out as ANSI (just using notepad) just it's...

J (8/28/2008)

---

Hmmm...

I do not remember where I read that, but apparently CDOSYS is much superior to CDONTS.

And I am getting confused here, is CdoNtsMail different from CDONTS ? A Web...

GSquared (8/28/2008)

---

Jeff, half my code posts aren't tested, because I don't have the data to test them or don't have the time. Trust me, those ones quite regularly have...

sql_er (8/27/2008)

---

Thanks for all the comments and suggestions.

My approach was as such:

1. Run Server Side Tracing for 15 mins on 5 almost identical dedicated sql servers (Subscribers in Transactional replication)....

sql_er (8/25/2008)

---

I was able to fix the problem without adding an index, but just re-writing the query.

It was strange how a very simple change in the query made it much...

Heh......

Almost forgot... at my previous job, the archive process ran nightly. At my current job, it runs on Monday and Thursday nights. First run may take a day...

Depends on what your partitions are based on. Mine are based on a "CampaignID"... any campaign that hasn't had a new row added to it in 90 days gets...

No... not what we're talking about... the spreadsheet would update itself from a view. No scheduling involved.

thomas.lemesurier (8/28/2008)

---

Hmmm, sorry that this is dragging on everyone, now that I have the files in the right place (;)) the tables are being picked up. However, when I open...

Thanks for the feedback, Simon... Gus is one of those tenacious posters... you landed a good one;)

Hint... 😉

sp_helplanguage

oxfield (8/27/2008)

---

thanks for the reply Paul...the earlier suggestion with a linked server works great... I just need my DBA to create the linked server in our dev environment (permission issue)..However,...