What format should the XML text be in for SQL2k?

[Don]

Hi,

When passing serialized object's XML from ASP.NET to a SQL Server 2k
sproc, what format should
I have the text in?

Here's my XML:

<ArrayOfEmployee xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Employee empid="" firstname="Joe" lastname="Johnson"
hiredate="01/01/2004" title="President" />
<Employee empid="" firstname="Bob" lastname="Smith" hiredate="02/01/2003"
title="Vice President" />
<Employee empid="" firstname="Jack" lastname="Hayes" hiredate="01/01/2000"
title="CFO" />
</ArrayOfEmployee>

When the sproc is called from the ASPX page, there are no errors, but no
records get inserted. When I do it manually myself with copy and paste from
notepad, it works. Any suggestions?

Thanks,

Don