In SQL Server 2000, how can you send an alert wi

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

(Continued from previous question...)

In SQL Server 2000, how can you send an alert without sending a message to the client?

Answer: xp_logevent

Explanation: The xp_logevent extended stored procedure will log an event in the SQL Server log file and the Windows Event log without sending a message to the client.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?
• When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?
• What does this return?
• What does a report model provide in SQL Server 2005 Reporting Services?
• What could be the problem if you know the service is working properly?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• Which query will return a list of the synonyms in your database?
• More...