You wish to configure event logging for your SQL

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

(Continued from previous question...)

You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?

Answer
Edit the nsservice.exe.config file in the C:\Program Files\Microsoft SQL Server\90\NotificationServices\n.n.nnn\bin folder.
Explanation
Event logging and most Notification Services configuration require editing an XML file. In this case, the NSservice.exe.config file is edited to set the appropriate editing level.

(Continued on next question...)

Other Job Interview Questions

• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• How do you recover the snapshot?
• What type of connectivity does the readpipe/makepipe utility test?
• True or false, Report Builder supports using the LIKE function inside filters?
• The TRUSTWORTHY database property is by default?
• When declaring an XML document, which type allows text nodes at the top level?
• On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• In SSIS, what is the difference between output columns and external columns?
• More...