Solved

drop SQL Mail account thru code

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

705 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

18 Experts available now in Live!

Get 1:1 Help Now