See the following Link to see more details based on an XML FILE...

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20670044.html

Linto

Edited by - linto on 11/10/2003 08:25:47 AM

See the following code....

DECLARE @hDoc int

EXEC sp_xml_preparedocument @hDoc OUTPUT,

N'<ROOT>

<Customers CustomerID="XYZAA" ContactName="Joe"

...

Whether you checked what ports your SQL Server is running ?

Linto

why don't u try by putting the statements inside a BEGIN --- END block ?

You can get the return values by adding a parameter named RETVAL and get the value after calling the ExecuteXXXX function...

see the following link for more details

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q310/0/70.asp&NoWebContent=1&NoWebContent=1

...