Our new Web-Services were Java-based with jdbc the only way we found was to change all our SPs to return only one Result-Set (with one xml column). Otherwise there was...

Any other suggestions?

- Does a table with "inserts-only" need index rebuilds? consider that it is some sort of statistics raw data, extracted every night (old data is cleaned up)

For the cdc tables there are only inserts. Thats why it seems really strange to mee that the indexes are fragmented. clustered index: 48 %, non-clustered index: 99,54 %

Extraction depends heavily how often we did it and wich period of the year. Sometime it took just to long.

We did no rebuild yet. I was not sure if it...

If I got you right you could:

Create an additional table with the 5 colums you mentioned. Add an artificial key to it (of type uniqueidentifier if possible).

Then, reference in every...

Hi,

I would definitly not recommend to store data in the cdc tables for long-term use! Extract the data nightly, thats the way it was thought.

You will run into troubles...

I implemented a similar thing with cursors.

I cant see your difficulties, multiple recipients can be added with a simple semi-colon separated list.

Finally, iterate over the cursor and call the senddbmail...

Hello,

I would also not recommend to store data in xml format for wich you need performant searches, although I think when one adds a typed xml (with the schema) to...

I totally agree that xml support in 2005/2008 is far better.

My question is more about how to access a SP that returns xml.

I wanted to know how you...