How to invoke a .asp file or .aspx file from a store procedure in sql server 2000
Hi,
Is there any way command which we can invoke a asp file or aspx file from a store procedure in sql server 2000 like we have for exe file.
If there is no command can you suggest me how to do this in sql server 2000 store procedures.
Bye.
What do you mean by invoke? Call and get the results from? Or return results from a stored procedure as HTML?
Using the xp_cmdshell stored procedure you can execute anything. FOr example you can execute an EXE which calls an ASP page... however you can't get anything back but the return code..
http://www.databasejournal.com/features/mssql/article.php/3372131
Important to note that xp_cmdshell will not display the user interface for the application (I think that was what kbradl1 was implying).
Not sure why you want to do this. Perhaps you could provide a bit more detail.
