While investment in architecture and reporting services (or quite simply with the wonderful Sqlbot) can solve these problems, SQL Server provides a mechanism for accomplishing this with the "sp_send_dbmail" stored procedure.Įasy to configure, this stored proc sends results to a list of email addresses, with several formatting and querying options. On a camping trip, far removed from civilization (and the database).An under-privileged employee lacking access to the database.A Non-SQL master without the chops necessary for querying database. ![]() Reporting the data can frustrate the most zen developer, for a variety of reasons. He wants his reports!īusinesses rely on data, and typically that data lives in a SQL Database. "Can you send us a report of this data every day?", asks the ever-eager, smiling business person as he knocks on your monitor to interrupt you. ![]() ![]() Sp_send_dbmail May Answer Your Reporting Problem
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |