If no parameter is specified, the default is NULL. It accepts only one email address as a valid value. The subject is of type nvarchar The message body is of type nvarchar max , with a default of NULL. The parameter is of type varchar 20 , with a default of NULL. When specified, the headers of the outgoing message are set to indicate that the message body has the specified format.
The parameter may contain one of the following values:. The parameter is of type varchar 6. The parameter is of type varchar Files in the list must be specified as absolute paths. The attachments list is of type nvarchar max. By default, Database Mail limits file attachments to 1 MB per file. The results of the query can be attached as a file, or included in the body of the e-mail message. The query is of type nvarchar max , and can contain any valid Transact-SQL statements.
The parameter is of type sysname , with a default of the current database. This parameter is only applicable if query is specified. When the value is 0, the query results are included in the body of the e-mail message, after the contents of the body parameter.
When the value is 1, the results are returned as an attachment. When the value is 1, query results contain column headers. When the value is 0, query results do not include column headers.
This parameter defaults to 1. The value provided must be between 10 and They can handle the volume, support more formatting options, and provide much better infrastructure and reporting around results.
While this handy proc works in a pinch, you will presumably eventually graduate beyond "just give me the data, it doesn't have to be fancy".
When that day comes, I'd recommend looking at a tool like Sqlbot in combination with a powerful collaboration hub like Slack you are using something other than email to run your business, correct? Having dedicated channels for reports is a powerful way of monitoring the business.
It also connects to non-SQL Server databases, which is a great way to scale reporting across multiple data stores and systems. SQLBot is free to signup, and affordable once you fall in love with it! I recommend playing with it for a bit to see what it can do, then keep it in your pocket for the next time SQL results are just beyond reach.
Happy databasing! What are you waiting for, it's free! Here's how. By Marty Mavis. Share this post:. He wants his reports! Nice work. Here they are:" "The DB has been deleted. May God have mercy on your soul" Combining this proc with SQL Agent, you can schedule reports to execute on a regular interval, giving you a bona-fide reporting infrastructure, all housed within SQL Server. What I'm Skipping Depending on your version and configuration of SQL Server, there may be some permission tweaks, random settings, and one blog even recommends gasp copying some binaries around beforehand.
MSFT's documentation was at the top of the results, with the high level description: "Sends an e-mail message to the specified recipients. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Visit chat.
0コメント