Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Basically, you can use DBMail, if that's your preferred method of sending e-mail from within SQL server. Here's <a href="https://stackoverflow.com/questions/1322281/sp-send-dbmail-will-not-send-query-results">another thread</a> that shows you an example and talking about limitation of sending query results via that method.</p> <p>So, add this to your scheduled job and you should get desired results.</p> <p>Here's how to control the query output and placement in the e-mail <a href="http://msdn.microsoft.com/en-us/library/ms190307.aspx" rel="nofollow noreferrer">straight from MSDN</a> if you want to use CSV or similar:</p> <blockquote> <p>[ <strong>@attach_query_result_as_file=</strong> ] attach_query_result_as_file Specifies whether the result set of the query is returned as an attached file. attach_query_result_as_file is of type bit, with a default of 0.</p> <p>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. This parameter is only applicable if @query is specified.</p> <p>[ <strong>@query_attachment_filename</strong>= ] query_attachment_filename Specifies the file name to use for the result set of the query attachment. query_attachment_filename is of type nvarchar(255), with a default of NULL. This parameter is ignored when attach_query_result is 0. When attach_query_result is 1 and this parameter is NULL, Database Mail creates an arbitrary filename.</p> <p>[ <strong>@query_result_header</strong>= ] query_result_header Specifies whether the query results include column headers. The query_result_header value is of type bit. 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. This parameter is only applicable if @query is specified.</p> <p>[ <strong>@query_result_width</strong> = ] query_result_width Is the line width, in characters, to use for formatting the results of the query. The query_result_width is of type int, with a default of 256. The value provided must be between 10 and 32767. This parameter is only applicable if @query is specified.</p> <p>[ <strong>@query_result_separator</strong>= ] 'query_result_separator' Is the character used to separate columns in the query output. The separator is of type char(1). Defaults to ' ' (space).</p> </blockquote> <p>If you want to use XML, you just have to make sure your query returns XML. Otherwise, you'd have to write a procedure to format tabular query as XML. </p> <p><a href="http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/62678/Printable" rel="nofollow noreferrer">Here's another route</a> using SSIS, but it's more involved, but gives you more control over the output and formatting.</p>
    singulars
    1. This table or related slice is empty.
    1. POAutomatically Email query Results in SQL Server 2005
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USdawebber
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAutomatically Email query Results in SQL Server 2005
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks a lot for the great response. I tried with the SSIS, but it proved to be a bit time consuming, so went with the DBMail. It works well, except it truncates my XML attachment at 2MB... any ideas on how to get around this?
      singulars
      1. PO
      1. USEv.
    2. CO@Ev, I think I can help here. Follow [this thread] (http://stackoverflow.com/questions/997628/how-do-i-increase-the-maximum-allowed-attachment-size-for-email-sent-using-msdb-d) and you should be able to increase it. Keep in mind that some e-mail systems have a max attachment size limitations set by admins on the receiving side. Also, rare as it may be, some outgoing SMTP server control that size also. Should this limit be exceeded, your e-mails will not reach the recipient and will bounce. Just an FYI, not necessarily a problem in your case.
      singulars
      1. PO
      1. USdawebber
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload