October 30, 2008 at 5:59 pm
Hey Guys,
I'm going through and tiding up the database mail accounts and profiles and i've got an issue with one stubbon profile that i just can't delete. I have successfully removed all the accounts associated with the profile. Can anyone shed any light on the following error
Delete profile '--Name witheld--'(Error)
Messages
Unable to delete profile '--Name witheld--'.
------------------------------
ADDITIONAL INFORMATION:
Drop failed for MailProfile '--Name witheld--'. (Microsoft.SqlServer.Smo)
------------------------------
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)
Cheers 🙂
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
October 30, 2008 at 7:35 pm
What service pack level are you on? I think this was fixed in SP2.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 30, 2008 at 7:41 pm
Yeah it quite probable to be a bug, because where still on RTM :w00t: I'm trying hard to get the powers that be to authorise a service pack upgrade. In the meantime are you able to suggest a possible work around ??
Cheers
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
October 30, 2008 at 8:02 pm
I assume you have been trying to run the delete using SSMS. Have you tried just using the sp in T-SQL without the @force_delete parameter?
select * from msdb.dbo.sysmail_profile
to get the profile id and then:
msdb.dbo.sysmail_delete_profile_sp @profile_id = [profile_id]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 30, 2008 at 8:36 pm
Champion! that worked a treat 😀
Thanks
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply