Solved

profile name in SQL Mail

Posted on 2011-02-15
5
259 Views
Last Modified: 2012-05-11
how can i see the name of the profile set up?


select * from msdb..sysmail_profileaccount gives only the profile id.


select * from msdb.sys.columns where name  like '%profile%' also shows profile_id not names..

thanks
0
Comment
Question by:anushahanna
  • 2
  • 2
5 Comments
 
LVL 6

Expert Comment

by:MuffyBunny
ID: 34899970
In Enterprise Manager, in the object explorer, open the Management folder. Right-click Database Mail and select Configure Database Mail.

Get to where the options are Set up Database Mail by performing...., Manage Database Mail accounts and profiles, Manage profile security, and View or change system parameters. Choose Manage Database Mail accounts and profiles. You should be able to figure it out from there.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34900007
thanks MuffyBunny.

will be doing this on multiple servers - so if there is a proc already for this, that will be great.
0
 
LVL 6

Assisted Solution

by:MuffyBunny
MuffyBunny earned 250 total points
ID: 34900292
Connect to msdb and run this

select * from sysmail_profile
0
 
LVL 39

Accepted Solution

by:
lcohan earned 250 total points
ID: 34900332
The SP below should give you all details you're looking for:

EXECUTE msdb.dbo.sysmail_help_principalprofile_sp

For more SQL Mail SP's please see: http://msdn.microsoft.com/en-us/library/ms177580.aspx
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34900535
thanks.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now