Add an XML column to your LOG_TABLE and add a FOR XML subquery:

'INSERT INTO LOG_TABLE (TABLE_NAME,Activity) SELECT ''' + @TABLE_NAME + ''', ''DELETE'''

+ ' (SELECT * FROM deleted...

I think that you will need to escape the second "-" in the pattern.

Heh. Yeah, I did see that one. I still can't understand why he thinks that...

I am using VSS, and it works OK with SSIS. Not great, just OK.

Well-Formed XML comes in two forms: The more expected "XML Document" and the less expected (but still "well-formed") "XML document fragment". The only difference is that XML documents have...

For (1-3), see...

How are you printing this Card? What are you using to format it?

Please post your current View definition. And just so you know, I doubt that this will be the panacea that you are hoping for. Output specific formatting like...

This sounds like an installation problem. What version, SP & edition of SQL Server did you install? And on what OS?

lmu92 (6/7/2009)

---

I'm also a little confused what kind of business case would require a coding like it's been asked for. I'm under the impression that the "business case" is a...

Thanks, Gail. And I agree, I don't think these more sophisticated system work very well at all.

I mean at first I thought that there might be a...

No, i wouldn't say that it was pompous or...

Heh, thanks for the assist, Gail. 🙂

As you can see, the very structured nature of the "threads" as StackOverflow (SO) make it very hard to carry on any kind...

GilaMonster (6/7/2009)

---

RBarryYoung (6/6/2009)

---

Though honestly, I've been finding both of these sites increasingly frustrating. The flaws of the "points for 'best' answers" systems they use becomes more evident the more...

By the way, where is the sign-up list?...