September 10, 2010 at 1:41 pm
Hi all,
We are getting this error when deleting a record in the database.. we do not have mail configured..
SQL Server blocked access to the procedute 'dbo.sp_send_dbmail' of component 'Database Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Database Mail XPs' by using sp_configure. For more information about enabling 'Database Mail XPs', see Surface Area Configuration" in SQL Server Books Online.
The statement has been terminated.
Is there any way to disable this??
THank you
September 10, 2010 at 2:02 pm
Do you have a trigger on the table that's trying to call the send mail stored procedure?
September 10, 2010 at 2:29 pm
No triggers at all in the database....
September 10, 2010 at 2:32 pm
That's definitely a trigger of some kind.
Run this on the database:
SELECT * FROM sysobjects where xtype = 'TR'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply