MSSQLTips

Hello, I need to generate an XML file from SQLServer 2000 (UTF-8 Format). Is there a way to do it? Thank you

HI, I would like to thank you for publishing such a wonderfull article. its really helpful to me. i would like to know more about the XML. i wants to start from very basic.As i am using MSsql form last year, i can get TSQL but, i want to become handy for the XML in T-SQL. Please suggest some good articles...

Mark, Thank you for the lengthy reply and feedback. Generic tables: You are correct, only specific columns are being audited with the 2 table generic solution. The requirement is not to audit the entire row. For the population, some of the data is populated via a trigger and other data is actually populated...