When u want to receive XML data from your stored procedure which containts a SELECT and UPDATE (processed records) statement, you can have some problems to Generate the SQL Adapter XSD.

When u press the last Window in the Wizard you could get an error message Failed to execute queury.

What we saw in the SQL Profiler is that the Generate SQL Adapter Wizard Executes twice the stored procedure Oops. The first one from Application name SQLClient provider and the second one from Visual Studio .NET 2003.

The first query execute returns the XMLDATA (XML Schema) , but also the stored procedure update. The second run executes the stored procedure once again without your XMLData schema.

So disable your update in your stored procedure and generate your XML schema after that enable the update and delete the XMLData option.

Good to know that the Wizard runs the stored procedure twice……