Please have a look at the DynamicCrossTab article referenced in my signature.

It seems like exactly what you need...

Google seems to be down, too.

I would first run a script and check for missing indexes. (I'm sure there are SS2K scripts out there...). Most probably a missing index issue as my first wild guess.

As...

Kendal Van Dyke has a video over at sqlshare about what's involved in converting our existing data to the XML data type.

http://support.microsoft.com/kb/306397/EN-US/

Edit: powered by SSC, the Google alternative 😉

Before following Gails great articles, you need to understand what the procedure you're trying to improve actually does.

Therefore, a brief code review is highly recommended (=mandatory).

Look for the obvious things...

It seems like your package include a step like file access or the like.

You have several choices: set up a proxy that's allowed to do it or rewrite your DTS...

iamanks (1/6/2011)

---

Hello Gila, Thanks for the information. We are currently storing xml code in ntext columns. While migrating to SQL 2008, I want to change them all to different datatypes...

deepikamm (1/6/2011)

---

sorry i am a beginner so it takes time for me to understand it.

another question

what are all the basic things i need to check up for tuning any stored...

What is the specific reason for not being an option...

Did you actually follow any of the links I pointed you at? Most of them include a line like "Install Oracle client"...

Maybe this link will help you getting started.

Hugo Kornelis (1/6/2011)

---

Being European, I think soccer when I read the workd football. And because I know next to nothing about football, I'll answer in soccer style.

The truly great soccer...

An SSIS package together with dedicated service account might be a solution, too.

But a CLR is most probably easier to design and maintain....

Chad Carter (1/6/2011)

---

The most I have seen at one time is a couple of hundred records so we should be OK. I will begin testing with it and getting...