Solved

drop SQL Mail account thru code

Posted on 2011-02-15
3
282 Views
Last Modified: 2012-05-11
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
Comment
Question by:anushahanna
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 500 total points
ID: 34899853
use sysmail_delete_account_sp
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34899861
worked like a charm- thanks.
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 34899863
You can also use the Database Mail Configuration Wizard to delete an account.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Square brackets 4 38
Joining Two Tables In SQL and combining records 6 52
tempdb latch contention 12 47
SQL Server merge records in one table 2 11
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now