?
Solved

profile_name for sp_send_dbmail SQL Server 2005

Posted on 2008-11-18
4
Medium Priority
?
1,091 Views
Last Modified: 2012-08-13
sp_send_dbmail takes several parameters, most importtant ones are
profile_name
recipients
subject

Is there a way to find the valid profile_name in the database and what the profile contains

Thanks

0
Comment
Question by:Greens8301
  • 2
  • 2
4 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 22985909
this will list all of the accounts:

exec msdb..sysmail_help_account_sp
0
 

Author Comment

by:Greens8301
ID: 22986018
Yes it does list the name, description, email address etc

Suppose I want to change the name ,  description, email address , what table/view  do I access

Thanks
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22986064
you can use this:

exec msdb..sysmail_update_account_sp

here are the params:

sysmail_update_account_sp [ [ @account_id = ] account_id ] [ , ] [ [ @account_name = ] 'account_name' ] ,
    [ @email_address = ] 'email_address' ,
    [ @display_name = ] 'display_name' ,
    [ @replyto_address = ] 'replyto_address' ,
    [ @description = ] 'description' ,
    [ @mailserver_name = ] 'server_name' ,
    [ @mailserver_type = ] 'server_type' ,
    [ @port = ] port_number ,
    [ @username = ] 'username' ,
    [ @password = ] 'password' ,
    [ @use_default_credentials = ] use_default_credentials ,
    [ @enable_ssl = ] enable_ssl

0
 

Author Comment

by:Greens8301
ID: 22986088
Can I diredtly insert to msdb..sysmail_profile
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Screencast - Getting to Know the Pipeline

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question