.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> SQL Query >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Database Mail Profile And Account ID

Posted By:Sasi Prabhu       Posted Date: June 28, 2011    Points: 40    Category: SQL Query    URL: http://www.dotnetspark.com  

To View Profile ID and Account ID.
 



sysmail_profileaccount

The sysmail_profileaccount is used to view the Profile and Account ID Details.

Query:



select * from msdb.dbo.sysmail_profileaccount

Sample Output :






     

Further Readings:

Responses
Author: Karthikeyan Anbarasan         Company URL: http://www.dotnetspark.com
Posted Date: June 28, 2011

Hi Sasi,

For these small code snippets you can place it in the Code section... Article section gives complete solution to problems.

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend