July 4, 2011 at 9:07 am
http://www.codeproject.com/KB/database/SQLServer2008DatabaseMail.aspx
i have followed this steps but i can't run attach mail..
July 4, 2011 at 9:27 am
Coolroof (7/4/2011)
http://www.codeproject.com/KB/database/SQLServer2008DatabaseMail.aspxi have followed this steps but i can't run attach mail..
I'm not positive what you mean for it could be interpreted different ways?
Can you send an email without an attachment?
What does you code look like and are you getting an error?
More information please.
Thanks.
USE msdb
GO
EXEC sp_send_dbmail @profile_name='PinalProfile',
@recipients='test@Example.com',
@subject='Test message',
@body='This is the body of the test message.
Congrats Database Mail Received By you Successfully.',
@file_attachments ='C:\MyFile.txt';
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 4, 2011 at 9:29 am
when adding the SMTP account what authentication did you use?
Windows
Basic
Anonymous
Have you verified the SMTP server address is correct?
What profile security did you select?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:33 am
i have used this format.. mailserver ip is correct..but without attaching work..
EXEC sp_send_dbmail @profile_name='Test',
@recipients='ss@ss.com',
@subject='Test message',
@body='sp_send_dbmail test',
@file_attachments='c:\test\test.csv'
July 4, 2011 at 9:34 am
how to check SMPT authendication..?
July 4, 2011 at 9:37 am
Coolroof (7/4/2011)
how to check SMPT authendication..?
when you ran the wizard it asked you how you want to authenticate to the SMTP server, what did you select??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:41 am
windows authendication
July 4, 2011 at 9:58 am
Coolroof (7/4/2011)
windows authendication
I'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:01 am
service type is SMTP,enable_ssl is 0 otherwise default
July 4, 2011 at 11:30 am
A training video on setting Database Mail. The volume is not very good.
Perhaps you missed something.
http://sqlserver-training.com/database-mail-sql-server-2008-video-tutorial/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 4, 2011 at 12:02 pm
Perry Whittle (7/4/2011)
Coolroof (7/4/2011)
windows authendicationI'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
:Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 2:53 am
Still having problem..attach mail only not going how to check..
July 5, 2011 at 9:44 am
thanks yar.. without administrator rights possiable to send mail in windows authendication sql server instance...?
July 5, 2011 at 10:13 am
pls i need help friends..
July 5, 2011 at 10:34 am
are you able to send a test email with no attachment?
Execute the following and post the full results, not just a subset
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply