How to Run SQL Queries for Detailed SMS DTS Job Status

  • Article

The following procedure demonstrates how to set up a query for SCRM 2006.

For detailed examples of the SQL queries used in SCRM 2006, see the following topics:

To run a SQL query for detailed status

  1. Copy the desired example SQL query onto the clipboard from this publication.

  2. Connect to the appropriate database by using Microsoft SQL Server 2005 Management Studio.

  3. Click New Query, and paste the query into the query window.

  4. Click Execute to run the query.

  5. Review the results.