Home Dashboard Directory Help
Search

Unable to delete profile in Database Mail by VincentYo


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 310453
Opened: 11/15/2007 1:11:44 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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

TITLE: Configuring...
------------------------------

Unable to delete profile 'DBA'.

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------
Details
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 Microsoft 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.

Thanks,

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,

jkh
Sign in to post a workaround.