InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:39:30 GMT20http://www.sqlservercentral.com/Forums/Topic1305490-2831-1.aspxYou do not have a default mail profile set up.select * from [msdb].[dbo].[sysmail_profile]select * from [msdb].[dbo].[sysmail_principalprofile]Run to see your profile names and if any are set to default.A "is_default" value of 1 is required. Thanks.Sat, 02 Jun 2012 11:08:48 GMTGeoff Ahttp://www.sqlservercentral.com/Forums/Topic1305490-2831-1.aspxGeoff,I have a DB Mail profile and account set up. I tested it and recieved an email. However, when I run the test script I get this error message. What am I missing?"Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107No global profile is configured. Specify a profile name in the @profile_name parameter."I was looking through the trigger for a place to define the profile name, but did not find anything.Fri, 01 Jun 2012 15:43:55 GMTlgarlickhttp://www.sqlservercentral.com/Forums/Topic1305490-2831-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Monitoring/89715/">How to receive alerts when you centralize your SQL Server Event Logs.</A>[/B]Wed, 23 May 2012 21:27:10 GMTGeoff A