sql 2005 sp_send_dbmail, what is "profile_name" ? 2

[henin]

OK, I'm ignorant but without asking i'll stay that way for ever.
Using "sp_send_dbmail" i'm required to provide value to: "@profile_name" argument. The trouble is i have no idea what it means..
How do i get to know what is my "profile_name" ?
Thanks.

 

[mrdenny]

When you configure database mail you have to setup a profile. The name you assign here would be the name that you provide for the @profile_name parm. If you run the sysmail_help_profile_sp procedure it will give you a list of the available profiles.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[henin]

Thanks a lot

 

[kjv1611]

I find this one pretty interesting for some possible uses, that I never thought about using SQL for.

So is the @profile sort of like a template email message?

--

"If to err is human, then I must be some kind of human!" -Me

 

[mrdenny]

The profile_name is the settings like the SMTP server, reply address, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kjv1611]

Ok, that makes sense. Thanks for that bit of info.

--

"If to err is human, then I must be some kind of human!" -Me

 

[henin]

Hi mrdenny !
where can i find sysmail_help_profile_sp procedure ?
I didnt find it in "master" stored procedures/

 

[mrdenny]

It's in MSDB.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog