C.1 Executing the Grooming SQL Server Stored Procedures

To immediately groom the GPO_REPOSITORY database, you can run a query to execute a Grooming SQL Server stored procedure.

NOTE:You can also groom the database on a schedule. For more information, see Section C.4, Scheduling Database Grooming.

To execute a SQL Server stored procedure:

  1. Start SQL Server Management Studio in the Microsoft SQL Server program folder.

  2. Connect to the SQL Server instance containing the GPO_REPOSITORY database with a login having db_owner privileges on the GPO_REPOSITORY database.

  3. Expand the Databasefolder and select GPO_REPOSITORY.

  4. On the toolbar, click New Query.

  5. In the right pane, type the query by using the syntax described in one of the following sections:

  6. On the SQL Editor toolbar, click Execute.