question

checking thee xml file i exported arise the following error: "Element type “P” must be followed by either attribute specifications, “>” or "/>"(checked by a xml editor) here is the code i used: IF OBJECT_ID('ClientInfo') IS NOT NULL DROP TABLE ClientInfo; GO CREATE TABLE ClientInfo ( ClientID INT PRIMARY KEY IDENTITY, xml_data XML ); INSERT INTO ClientInfo (xml_data) VALUES ( ' John Doe Jane Doe ' ); declare @xml_convert nvarchar(4000) set @xml_convert='bcp "select xml_data from ClientDB.dbo.ClientInfo" queryout C:\Test\1.dat -S '+@@servername+' -T -w -t;' EXEC master..xp_cmdshell @xml_convert what is wrong?