Post reply

Mail in sql server 2008

  • July 4, 2011 at 9:07 am

    #240230

    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

    #1347926

    Coolroof (7/4/2011)

    http://www.codeproject.com/KB/database/SQLServer2008DatabaseMail.aspx

    i 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

    #1347930

    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

    #1347931

    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

    #1347935

    how to check SMPT authendication..?

  • July 4, 2011 at 9:37 am

    #1347937

    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

    #1347940

    windows authendication

  • July 4, 2011 at 9:58 am

    #1347952

    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

    #1347954

    service type is SMTP,enable_ssl is 0 otherwise default

  • July 4, 2011 at 11:30 am

    #1347984

    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

    #1347992

    Perry Whittle (7/4/2011)

    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

    :Whistling:

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 5, 2011 at 2:53 am

    #1348110

    Still having problem..attach mail only not going how to check..

  • July 5, 2011 at 9:44 am

    #1348379

    thanks yar.. without administrator rights possiable to send mail in windows authendication sql server instance...?

  • July 5, 2011 at 10:13 am

    #1348413

    pls i need help friends..

  • July 5, 2011 at 10:34 am

    #1348444

    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