(Continued from previous part...)

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.

What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski:
USE Northwind
GO
CREATE PROCEDURE sp_who
AS
PRINT 'SURPRISE'
GO
EXECUTE sp_who

Answer
Information about current SQL Server users and processes is displayed.
Explanation
The explanation could be found in the Books Online under Creating a Stored Procedure. One of the sections, named System Stored Procedures which describes how SQL Server looks up the system stored procedure has this note: Important If any user-created stored procedure has the same name as a system stored procedure, the user-created stored procedure will never be executed.

How is Thesaurus data configured in SQL Server 2005 Full-Text Search?

Answer
An XML file in the file system named tsxxx.xml where xxx is a code.
Explanation
The thesaurus file for SQL Server 2005 is an XML file containing data and stored in SQL_Server_install_path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\ directory. There is one for each language and it is named tsxxx_.xml, where xxx is the three letter language code.

What does a report model provide in SQL Server 2005 Reporting Services?

Answer
A report model provides familiar business names for database tables and fields
Explanation
A Report model provides business names and terms for database fields and tables. It allows for predefined relationships between tables as well as grouping items together logically.

(Continued on next part...)