Requires experts help

Hello,
In my application I need to call a HTTP address from the SQL server.Can I call the HTTP address within a stored procedure?
Are there any ways to call HTTP address using SQL server?
Awaiting for the reply.
RegardsOriginally posted by SPathak
Hello,

In my application I need to call a HTTP address from the SQL server.Can I call the HTTP address within a stored procedure?
Are there any ways to call HTTP address using SQL server?

Awaiting for the reply.

Regards

what do u want to do exactly after calling the http address?
do u want to access any data on the page or something?
please clarify a bit more|||Refer to books online for Executing SQL Statements Using HTTP topic.|||I need to call the ISAPI dll in the IIS virtual directory from stored procedure.Can it be possible?|||Originally posted by SPathak
I need to call the ISAPI dll in the IIS virtual directory from stored procedure.Can it be possible?

it is quite possible ,use sp_oacreate,
for details refer to BOL.|||As I am new to this Can you explain me in detail how to create the http object using this procedure.|||As its been suggested twice already..

READ Books On Line for more information.|||Well, for this reason I always suggest to refer to books online for any information. Hope few times you may not get much insight about the issue but it helps you to asses.