Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tjl0079
Starting Member
10 Posts |
 Posted - 2009-03-10 : 10:52:11
|
| Does anyone know is it even possible to call a asp.net page from SQL with a stored procedure or trigger |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-10 : 11:47:02
|
| Not sure what your exact needs are but you could do this from Powershell. It is outside of sql server but could be invoked via SP. Not sure why you would want to do it but that would be a work around.Mike"oh, that monkey is going to pay" |
 |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2009-03-10 : 11:49:07
|
| In short, yes.We use sp_OACreate to create an MSXML object which we then use to "hit" any page we need to on our web site, you will need to do some surface area configuration in 2005 to get it working.We dont receive any data back from the page, we just use as a kind of web scheduler, some pages get hit on a regular basis and these are hit from sql tasks |
|
|
|
|
|
|
CALLING A .NET PAGE