Database Mail

• SQLRep

  SSCrazy

  Points: 2052

  More actions

  December 14, 2006 at 10:40 am

  #174058

  Hi i am rtying to run Database mail from sp_send_dbmail

  but it fails by saying that Profile name is not valid.

  I want to set the Profile name to be System name (servername) (testServer)

  how can i do that!!

  this is what i am trying to do

   

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name ='',--I want to send Servername

  @recipients = 'test@test.com,

  @subject = 'Test';

  Thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 14, 2006 at 11:47 am

  #678168

  Use database mail configuration wizard or procedures...

  SQL Server 2005 Books Online 

  Welcome to Database Mail Configuration Wizard 

  http://msdn2.microsoft.com/en-us/library/ms177215.aspx

  Database Mail Configuration Stored Procedures 

  http://msdn2.microsoft.com/en-us/library/ms175862.aspx

   

  http://msdn2.microsoft.com/en-us/library/ms190307.aspx

   

  MohammedU
  Microsoft SQL Server MVP