Add the stored procedure

To optimize the response time of WRS®, it is necessary to design a SQL stored procedure. To add this procedure:

  1. go to WRS® installation archive folder;

  2. in the Scripts SQL directory, click on the bilFIL45.sql file;

→ the SQL Server Management Studio tool is launched;

  1. log on to the SQL Server Management Studio tool by using the SQL or MS Windows® administrator account;

  2. in the database dropdown list, select Watchdocstats:

     

If the database name display field is empty and greyed, click first in the right frame in which is displayed the SQL request.

 

  1. click on the Run button;

→ The following message is displayed: Command(s) completed successfully.

  1. check that the stored process is correctly installed by deploying the watchdocstats database tree: