quick and easy way to access sql server table data as tab-delimited text?

• sqlguy-736318

  Hall of Fame

  Points: 3859

  More actions

  September 20, 2011 at 3:10 pm

  #248311

  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?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 20, 2011 at 3:14 pm

  #1384198

  sp_send_dbmail

  can send an e-mail (scheduled via job).

  You can send file or attach the results of a query as file.