I am trying to create an xml from a table with tags for each field in the table. Basically i am trying to run following query in SQL Server 2005
SELECT * FROM customer FOR XML AUTO, ELEMENTS,
This gives an error.
Line 2: Incorrect syntax near 'ROOT'.
I think ROOT command is correct so not sure where the problem is. Do i need to change any settings on SQL Server?