Couldn’t send mail with MS SQL Server 2005
Posted on July 1, 2010
So I've been struggling trying to send SQL Agent job notifications to operators.
- Msg 515, Level 16, State 2, Procedure sp_validate_user, Line 19
- Cannot INSERT the value NULL INTO COLUMN 'permission path', TABLE '@temp'; COLUMN does NOT allow nulls. INSERT fails.
- The statement has been terminated.
- Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107
- No global profile IS configured. Specify a profile name IN the @profile_name parameter.
Turns out you don't need a @profile_name parameter if you set the mail profile to default.
To do to this set up a global or default profile go to Database Mail -> Right-click -> Configure Database Mail.
Select "Manage profile security" and on either the public or Private profiles tab select the Profile you want and set the Default Profile property to Yes.
Now whenever you do not provide the @profile_name parameter this profile will be used.
Related posts
- “Mail option not available!”
I spotted a strange PHP "feature" in the error_log() feature. PHP checks for sendmail functionality... - WP-O-Matic Bug Fixes Round Up
I've run into quite a few issues in the latest 1.0RC3-7 release of WP-O-Matic. Here's... - [Snippet] Connecting to Windows 2008 Server from XP
By default, Windows 2008 requires Network Level Authentication to connect via RDP/Terminal Services. This is... - I heart MDB2
I recently started a project for a customer, if it's CubeCart, WordPress or BackPress based,... - How can I specify the Global Catalog (GC) that I want my Microsoft Exchange Server system to use?
If you want to force the Exchange server to use a specific GC instead of...
March 27th, 2011 - 22:20
I and my buddies were found to be reading through the best procedures from your web page then at once got a terrible feeling I never expressed respect to the blog owner for those tips. Those ladies had been certainly excited to read through them and have very much been enjoying them. I appreciate you for genuinely indeed considerate and for pick out certain superb subject matter millions of individuals are really eager to understand about. Our own sincere regret for not saying thanks to you sooner.
March 27th, 2011 - 23:29
You made fantastic extremely interesting