Unable to delete profile in Database Mail - by VincentYo

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 310453 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/15/2007 1:11:44 PM
Access Restriction Public


When attempting to delete an existing Database Mail Profile  in SSMS, I get this error:

TITLE: Configuring...

Unable to delete profile 'DBA'.


Drop failed for MailProfile 'DBA'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+MailProfile&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


@force_delete is not a parameter for procedure sysmail_delete_profile_sp. (Microsoft SQL Server, Error: 8145)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=8145&LinkId=20476


Sign in to post a comment.
Posted by swordfishhh on 1/7/2010 at 8:31 AM
I have found a solution!!

Try this tsql.

select * from msdb.dbo.sysmail_profile

msdb.dbo.sysmail_delete_profile_sp @profile_id = <profile_id>
Posted by swordfishhh on 1/7/2010 at 7:50 AM
Hi there,
Any updates on this error?!
Posted by Amy [MSFT] on 6/10/2009 at 9:44 AM
I have closed this bug not repro - we can not reproduce this issue in house with SQL2008.


Amy Lewis
Posted by Microsoft on 12/4/2007 at 8:39 AM
Thanks for reporting your problem deleting db mail profiles. It looks like we may be able to address this in our next major release.

Thanks again,