Nice recovery from a nasty situation. I did not know that would cause SQL not to start. I'll be adding that to my 'by the way' notes for future reference.

lol - nice spot!

try the tip mentioned before "until I ran it as a cmdexec job from the info I got using the information supplied on the previous page to do this.  That...

this has been resolved in SP2, fyi. My alerts no longer have this issue

If that meets your user requirements, then that's what matters. How many users, and how many documents, do you have, if I might ask?

Our XML columns, where used and when...

Interested to know how you handle accessing the data, after you've stored it. Fetching the entire XML = far more IO, memory and netowrk usage than might be required, if...

Grant, I can confirm that your experience matches ours. We are now looking at standardizing on using XML whenever we need to have a repeating set of data given to...

Simon, interesting article.

Our client has used XML in certain areas of designs, with varying degree's of success. For static data, it can be relatively effective, but, as you mention, as...

thanks for the responses Daniel. Haven't played with the SQL logging since my 1st/2nd package - our client preferred to to log for SQL.

... how did you do it?

The best way I've found, so far, is to run the SSIS package as a command line from a SQL agent job, and under the...

My stand - I liked the article (very well, and professionally, written imho),I want to understand the technique, but am NOT in favour of it's usage in almost any circumstance...

yes, it is POSSIBLE, but only by having the declaration of the variable, population of the table variable, and usage of the table variable, ALL INSIDE THE DYNAMIC SQL.

not something...

Quite a nice article, but, as has been pointed out here, a table variable 'does' create in tempdb. In fact, I tested this, and was able to show a growth...

Colin,

You are completely correct that table variables are justly famous for big improvements on small resultsets, especially in savings on re-compliations on SPs. The question always seems to remain -...

Just to add in on this

- table variables cannot be indexed, while temp tables can.

-Table variables cannot be trunacted (afaik), temp tables san.

After a certain size (who knows...