Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

drop SQL Mail account thru code

i added a mail account using
msdb.dbo.sysmail_add_account_sp

i need to drop it and add it again with correct parameter. what would be the right proc to drop it?

thanks
0
anushahanna
Asked:
anushahanna
  • 2
1 Solution
 
LowfatspreadCommented:
use sysmail_delete_account_sp
0
 
anushahannaAuthor Commented:
worked like a charm- thanks.
0
 
LowfatspreadCommented:
You can also use the Database Mail Configuration Wizard to delete an account.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now