I have created a web app that uses SQL Server. The web app sends emails and logs emails sent and email exceptions to the database.
I want to be able to quickly and easily check the email/exception log. I don't want to spend time to build a web page around this.
I'd like to create a shared directory on the server where I can simply double-click a bat file and a text file of the log will be opened. So behind the scenes, the bat file simply queries the database and at the end opens an output test file of tab-delimited data.
Is this possible? If so then how hard is this to do and how would I go about doing this?