Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Run ASPX file from Stored Procedure? Expand / Collapse
Author
Message
Posted Monday, December 9, 2013 7:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 14, 2014 7:39 AM
Points: 111, Visits: 307
Hey,

After my Stored Procedure has run, I need to call a https://site/blablabla.aspx file. Can this be done from my Stored Procedure?

Thx,
Raymond
Post #1521089
Posted Monday, December 9, 2013 8:53 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:00 PM
Points: 4,196, Visits: 3,235
Raymond van Laake (12/9/2013)
Hey,

After my Stored Procedure has run, I need to call a https://site/blablabla.aspx file. Can this be done from my Stored Procedure?

Thx,
Raymond

Not as far as I know, and I don't think you'd want to do so anyway. Stored procedures run on the server. Opening an web page from the procedure would open it in a browser on the server and if it was running unattended, there wouldn't be anyone there to see it. Personally, I don't like to surf the web from servers at all. There's usually no real need to and you're consuming resources that would probably be best left to doing server-type things.

If the ASPX page contains .NET code you have to run after your procedure completes, look into creating a .NET assembly. http://msdn.microsoft.com/en-us/library/ms254956%28v=vs.80%29.aspx. I like to keep everything in SQL, but I understand there are some things you cannot do with SQL. An no, I'm not trying to inspire a debate with that statement.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1521154
Posted Monday, December 9, 2013 8:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
That is a yes/no question. The answer is Yes BUT you can't do it without some work. You'll need to write a SQLCLR to do it that way. Or if the call can be deferred write the information into a table and have an SSIS package do it with a script task. Its a lot less painful. A lot of the same code in the SSIS package but easier to get running..

CEWII
Post #1521155
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse