Permissions For Xp_smtp_sendmail?

Apr 14, 2008

(Apologies if this is in the wrong section.)

I'm been using xp_smtp_sendmail in SQL2000 for firing off task assignment emails from a ASP.NET website which uses Integrated security to connect.

Everything has been fine in the past but now these EMail have stopped being sent. (Can't give an accurate date as to when)

The same thing is now happening on my local machine as well, everything appears to run fine - xp_smtp_sendmail does not send back an error code it's just that the EMail is not sent. The unusual thing is that if I run the exact same code (lifted from Profiler) in SQL Analyser then the mail is fired off no problem.

Things I have tried...
Set Chaining in Calling DB.
Set Website conn string from integrated to use sa login.
Opened up permissions for ASPNET user.
Created sproc in master to do call to xp.
Reloaded xp_smtp_sendmail and set permissions.

I'm now at a dead end and would be grateful for any helpideas.

View 2 Replies

Xp_smtp_sendmail

Aug 2, 2006

Any idea when this extended stored procedure gets installed in SQL 2000 as I get just the error message below when I try to run it:

Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.

View 3 Replies View Related

Xp_smtp_sendmail With 64-bit Version? (was DBA)

Aug 3, 2006

does anyone knows if there is such xp_smtp_sendmail with 64-bit version?

View 1 Replies View Related

Xp_smtp_sendmail/xpsmtp80.dll

Sep 8, 2006

Hi!

I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:Program FilesMicrosoft SQL ServerMSSQLBinnDLL. Then I registered it by exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com',
@subject = N'My first HTML mail',
@message = N'<HTML><H1>This is some HTML content</H1></HTML>',

@type = N'text/html'
select RC = @rc
go

An error generating stating

ODBC: Msg 0, Level 16, State 1

Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

(1 row(s) affected)

Please anyone help me to sort out this problem.

View 1 Replies View Related

Problems Using Xp_smtp_sendmail

Jul 20, 2005

I am trying to use this code to send an emaildeclare @rc int,@invjournal intset @invjournal = 2222exec @rc = master.dbo.xp_smtp_sendmail@FROM= N'matt@hasta.se',@FROM_NAME= N'Matt Douhan',@TO= N'inventering@hasta.se',@replyto = N'Reply to NONE',@CC= N'',@BCC= N'',@priority= N'NORMAL',@subject= N' TEST TEST TEST Inventeringsjournal '+@invjournal+'klar f�r integration till redovisningen TEST TEST TEST',@message= N'V�nligen uppdatera denna inventeringsjournal tillredovisningen',@messagefile= N'',@type= N'text/plain',@attachment= N'',@attachments= N'',@codepage= 0,@server = N'mandarin.internal.hasta.se'select RC = @rcgobut it fails with the following with the following error msgServer: Msg 170, Level 15, State 1, Line 14Line 14: Incorrect syntax near '+'.the problem seems to be when I want to use the @invjournal variable inthe subject, if I take it away and only send text it works just fine.Any ideas would be much appreciatedrgdsMatt

View 1 Replies View Related

The SMTP Server In Xp_smtp_sendmail

Sep 23, 2005

Just trying out xp_smtp_sendmail for the first time.I get the error:Error: connecting to server smarthostOK, so I don't have the server parameter for SMTP server set upcorrectly.I don't even know what an SMTP Server is! Is this an e-mail providerthat provides SMTP functionality, or an application I need to install?

View 4 Replies View Related

Xp_smtp_sendmail Not Sending HTML File Right

Sep 27, 2007

Hello All.

I sent a HTML file as text message using xp_smtp_sendmail from my SQL server but the test email that I received doesn't look like the HTML file I have originally. Below are my codes:-

exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'xxx@yyy.com',
@FROM_NAME = N'Mr XXX',
@TO = N'www@yyy.com',
@CC = N'kkk@yyy.com',
@priority = N'HIGH',
@subject = N'Weekly Sales To Thirds',
@type = N'text/html',
@messagefile = N'D:WSTWeeklySalesToThirds.htm',
@server = N'999.99.999.99',
@attachments = N'D:WST4weeksWST.xls'
select RC = @rc

The problem I have is the email doesn't display the HTML correctly. Spaces appeared and some of wording have wrapped.

I have attached partial screen shots of my original HTML file and email.

Please help if you have similar problem and solution. Thank you.

Best regards
Teck Boon

View 2 Replies View Related

Xp_smtp_sendmail Html+plain Text

Jul 20, 2005

Hi all. Iv'e tryed out xp_smtp_sendmail, and I like what I can see sofar. The thing I wonder about is if the xp supports sending both htmlAND plain text in the same mail. I'm on a sql2000 sp3 and I have noproblem with the xp when i either send plain text or html, but asstated above I need to send with both formats in one mail......For use when one does not know if the receiver uses a mail-client thatsupports html or not. If not does anyone know of a good way to attackthis problem?thanks in advanceKarl B

View 1 Replies View Related

Trigger :: Xp_smtp_sendmail :: Parameter Value In Message/subject :: Magic Table

Oct 23, 2007

OK so now I'm setting up a trigger to email info to different people based on values INSERTed into one of my tables. I'm using an IF statement to determine who I'm giong to send the mail to, but I don't really understand how to include the data (parameters) in my message. Thanks for any help. Here's what I have so far.

Code Block
ALTER TRIGGER [smallin].[trig_test]
ON [smallin].[DATALIST]
AFTER INSERT
AS
declare @rc int,
@post bit,
@pre bit
SELECT @post = [POST], @pre = [PRE] FROM inserted
IF @post = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is post data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'

ELSE IF @pre = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is pre data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'

View 5 Replies View Related

Table Permissions Versus View Permissions

Aug 2, 2006

Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.