Re: Get XML On Its Merry Way



Hello Lauren

No, in SQL Server 2000. You should make webservices yourself.

There is a /create endpoint/ statement which exposes your stored procedures
or UDFs as webservice. But it's only available in SQL 2005. With that you
can create proxy class on your web server.

"Lauren Quantrell" <laurenquantrell@xxxxxxxxxxx> wrote in message
news:1169125941.462554.185310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Apologies ahead of time for XML newbie...

I can use the FOR XML clause in SQL Server 2000 to create an XML
representation of a SELECT recordset, but what is the method to get
this XML outbound from SQL Server to the WebService on my server (using
SOAP)?

Anything that points me in the right direction is appreciated.
lq



.



Relevant Pages

  • Re: ThreadAbort Exceptions !! HELP !!
    ... Well we checked for queued requests last night and there were none during ... Looks like our SQL server box is ... trace seems to usually point at a webservice not an aspx page. ... System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Scalability questions....
    ... Hardware code is faster than software code (i.e. hardware SSL is faster than software SSL). ... We averaged 60 MB/sec of bandwidth and used SQL Server to log and analyze the downloads. ... But how do I write a data intensive webservice that can be ...
    (microsoft.public.dotnet.general)
  • RE: Webservice can not connect to Sql server 2000
    ... Windows service pack. ... All i am dong is trying to open a connection from a .Net webservice (using ... IIS installed on it and connecting to the sql server which is running on ...
    (microsoft.public.sqlserver.connect)
  • Re: WebService Datenhaltung
    ... der DB lädt und zum Schluss eine XML-Datei ins WebService Verzeichnis ... der temporären Daten aus dem SQL Server, so das auch recht wnig Ressourcen ... aktuelle Dataset aus dem WebService als XML schreiben (eine Art ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Proxy Authentication error when calling a webservice from SQL2K stored proc
    ... I'm performing a webservice call from a SQL Server stored proc. ... Authentication Required.' ...
    (microsoft.public.sqlserver.programming)