Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Send query result as HTML Mail Expand / Collapse
Author
Message
Posted Friday, March 21, 2008 8:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 3:27 AM
Points: 3, Visits: 116
Comments posted to this topic are about the item Send query result as HTML Mail
Post #473173
Posted Monday, May 12, 2008 7:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:09 AM
Points: 2,656, Visits: 19,184
Article says "SQLServer 2000 and Windows 2000 ONLY" - will this not work in XP?

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #498765
Posted Monday, May 12, 2008 2:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 3:27 AM
Points: 3, Visits: 116
This script is working on SQL 2000 / Windows 2003 server.
I do not test it on other configuration.
But I suppose that that should work.

Daniel Eyer
Post #499117
Posted Wednesday, June 11, 2008 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 11:09 AM
Points: 2, Visits: 213
This still has the 8000 character limitation does it not?

Has anyone found a way around that? Is it possible to bypass this with 2005?



Post #515299
Posted Monday, August 18, 2008 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 1, 2014 8:38 AM
Points: 1, Visits: 6
can any body tell how to email from sql
Post #554176
Posted Thursday, March 19, 2009 11:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 24, 2014 2:32 PM
Points: 1, Visits: 60
I am setting up trigger to send out query results and this is exactly what I needed.

It works perfectly. Whoever you are, thanks a bunch!!!

This is awesome.
Post #680145
Posted Wednesday, April 15, 2009 10:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:13 PM
Points: 3, Visits: 12
yes this does work well but the only issue l am having is the header row on the query is 2 rows high for some reason. Anyone esle having the same issue

Post #698143
Posted Wednesday, July 8, 2009 11:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:13 PM
Points: 3, Visits: 12
Can anyone help me with this sp to include the ability to add a header before the results anda footer after the results. I have teried but the results keep generating erratically.
Post #749873
Posted Wednesday, July 8, 2009 11:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:13 PM
Points: 3, Visits: 12
Can anyone help me with this sp to include the ability to add a header before the results anda footer after the results. I have teried but the results keep generating erratically.
Post #749875
Posted Wednesday, December 2, 2009 10:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 3, 2014 4:05 AM
Points: 9, Visits: 172
Hi All,

I have created the same Stored proc & execute the SP as
exec sp_send_MailHtml
'smtp.entech.us', --SMTP Server
'webmail.'
'sharad@entech.us', --From
'jatin@entech.us', --To
'sharad@entech.us', --CC
'', --CCi
'Test Page', --Subject
'select top 2 * from superaccesslevels..totaldatabase'



But i have not received any mail.

Can someone plz let me now what is the issue in this & how to resolve it ?


Sharad
Post #827943
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse