What is the recommended way to send mail from SQLAgent in SQL Server 2005? - Database Mail You can use either Database Mail or SQLMail with SQL Agent in SQL Server 2005. However since SQLMail will be removed, it is recommended that you use Database Mail. - SQL Server Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL SERVER

DETAILS

Question: What is the recommended way to send mail from SQLAgent in SQL Server 2005?

Answer: Database Mail
You can use either Database Mail or SQLMail with SQL Agent in SQL Server 2005. However since SQLMail will be removed, it is recommended that you use Database Mail.

Category	SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8521 users
Added on	9/14/2014
Views	66984
Rate it!

Question: What is the recommended way to send mail from SQLAgent in SQL Server 2005?

Answer:

Database Mail
You can use either Database Mail or SQLMail with SQL Agent in SQL Server 2005. However since SQLMail will be removed, it is recommended that you use Database Mail. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not?	View Answer
	How many Service Packs will be released for SQL Server 2005 in 2007?	View Answer
	In which order do you perform an upgrade to SQL Server 2005 for replicated databases?	View Answer
	Error severity 13 indicates what?	View Answer
	What is SQL Server ?	View Answer
	What is the difference between weak entity set & strong entity set?	View Answer
	What is data base system? What is dbms? Give the difference between that and give the information about data base catalog?	View Answer
	What is joins? What is the use? Where it is use?	View Answer
	How a sql server is been used in our programs?	View Answer
	How can i install a sql server software in a pc?	View Answer
	How to replace particular string. For example:- suppose their are 1000 of records for email-id. like [email protected] i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.	View Answer
	How to get the list of tables in Sybase?	View Answer
	What is Extended Stored Procedure in SQL Server 2000?	View Answer
	What is the difference between sql server,database server and oracle server?	View Answer
	What is the Disadvantage of StoredProcedure?	View Answer
	Explain about Dead-locks in Sql Server database	View Answer
	How we can make sure that the SQL query does not return NULL values?	View Answer
	Name of the class of SQL?	View Answer
	What is the difference between Varchar and Varchar2?	View Answer
	What is the difference between Inner join and full outer join in terms of the Number of rows return	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Server Interview Questions & Answers - Exam Mode / Learning Mode