Where are Notification Services event messages l

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

(Continued from previous question...)

Where are Notification Services event messages logged in SQL Server 2005?

Answer
In the Windows Application Log
Explanation
Event messages are logged in the Windows Application log.

(Continued on next question...)

Other Job Interview Questions

• What is row versioning in SQL Server 2005?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• You want to partition these past orders columns into a new table. What type of partitioning is this?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• Using Report Builder, which of the following statements is correct about formatting numbers?
• How can you easily monitor to see if this assembly is being used?
• No column permissions are assigned. What should you do?
• More...