How can SQL Server Agent Mail send messages in S

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can SQL Server Agent Mail send messages in SQL Server 2005?

Answer
SQL Mail through Extended MAPI or Database mail.
Explanation
SQL Server Agent Mail can be configured to use Database Mail or Extended MAPI.

(Continued on next question...)

Other Job Interview Questions

• You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• How many connections are available in SQL Server MSDE 2000?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin
• What result would you expect from this statement? Select * from dbo .MyTable
• What does the tablediff utility do?
• More...