Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transact SQL Send String via HTTP
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00762886
Message ID:
00763331
Views:
18
I'm confused. Are you trying to PULL or PUSH xml out of SQL Server? You can retrieve xml (PULL) from SQL Server by using the FOR XML clause on your queries. The XML will be returned to the client as a stream instead of a result set.

PUSHing is a different story.

-Mike

>Thanks Eric, I'll take a look at this. Once it is set up on the Web server, then what steps are needed within SQL Server? If you could just point me in the right direction to find this info I'd appreciate it. And thanks for the quick reply!
>
>George
>
>>There is alot eaiser way to get xml out of a sql server over HTTP. Assumin you have iis running on the sql server, goto the sql server in the start menu, select configure sql xml support in iis. Select your website, right click select new virtual directory and follow the wizard.
>>
>>Eric
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform