Your department is responsible for immediate response to error conditions reported by your company's financial application. The application logs all errors to a table named FCAudit, located in a Microsoft SQL Server 2005 database.

Severe errors contained in the FCMessage column are prefixed with the string FC-Severe. When these Severe errors are written to the FCAudit table, your entire team would like to be notified by the wireless technology of choice (i.e. pager, cell phone text messaging, PDA, etc.)

To do this, you will set up the Attention! AM SQL Agent to scan, at 15-minute intervals, the FCMessage column of the FCAudit table. The SQL Select statement will search for any message containing the string FC-Severe. When Severe messages are detected, that entire row of the FCAudit table will be sent to the Attention! AM Server as a tab-delimited sequence of fields.

To make certain the Attention! AM Server is not overwhelmed with too many messages, the Attention! AM SQL Agent will send a maximum of 50 rows at one time.

Enter the following SQL Select statement in the Attention! AM SQL Agent:

     Select * from FCAudit
     where FCMessage LIKE '%FC-Severe%'