<div>
Write a COM dll to do this in VB, then call the dll using<br />
<br />
xp_OACreate<br />
xp_OAMethod and<br />
xp_OADestroy<br />
<br />
bukko
</div>


Write a COM dll to do this in VB, then call the dll using

xp_OACreate
xp_OAMethod and
xp_OADestroy

bukko

<div>
My developer is trying to avoid doing this using a VB component or an NT Serivce, I am told
</div>


My developer is trying to avoid doing this using a VB component or an NT Serivce, I am told

<div>
Then the developer will have to code directly against the MSXML dll using the extended stored procedures mentioned previously by bukko <br />

</div>


Then the developer will have to code directly against the MSXML dll using the extended stored procedures mentioned previously by bukko


<div>
I will mention this to him and see what he thinks. Thanks for now.
</div>


I will mention this to him and see what he thinks. Thanks for now.

<div>
Ahhh, this looks more like it. Let me see what my developer thinks of this link. Thank you kselvia.
</div>


Ahhh, this looks more like it. Let me see what my developer thinks of this link. Thank you kselvia.

<div>
<div class="content wysiwyg-content">
One of the developers on my team needs to make an HTTP call in a stored procedure in SQL server 2000. This procedure runs at midnight every night and we need to send an HTTP POST at certain points throughout it. However, the developer is unsure of how to do this exactly.<br />
<br />
Does anyone know how I can make a HTTP call in an SQL query?
</div>
</div>


One of the developers on my team needs to make an HTTP call in a stored procedure in SQL server 2000. This procedure runs at midnight every night and we need to send an HTTP POST at certain points throughout it. However, the developer is unsure of how to do this exactly.

Does anyone know how I can make a HTTP call in an SQL query?

HTTP POST through SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.