Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 2 down vote favorite

Currently I have a procedure that displays disk information by sending an email to the user.

I'd like to create a link within the email that when clicked, executes a different procedure stored on that server.

Is this possible to do in SQL Server?

Would I have to perhaps pass an osql command, or something of that sort?

share|improve this question
1  
Does you SQL server have the ability to receive emails and process them? Sending emails is easy. Teaching it to fetch and read them is a whole other matter. – John Gardeniers Feb 13 '12 at 20:42

1 Answer

up vote 2 down vote accepted

You can install IIS on that server, or on another one, and then put a small web application in it that connects to SQL Server and runs the procedure when invoked. So you could have a URL like http://your.sql.server/YourApp.aspx (or .asp, or .php... ASP.NET is probably the easiest approach) that runs the procedure when clicked.

Of course, while it would be quite easy to throw in such a quick-and-dirty solution, a proper one would require a lot more care (just think about user authentication).

share|improve this answer
That's exactly what I needed to know. Thank you. – Michael Capobianco Feb 13 '12 at 21:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.