Solved

drop SQL Mail account thru code

Posted on 2011-02-15
3
291 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

832 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