Manual installation of SQL Server stored procedures

If you deselected the Execute SQL Scripts feature during the installation, you must install the SQL stored procedures manually.

Note: To install the PI ML SQL stored procedures, the minimum permissions required are CREATE PROCEDURE permission in the PI Manual Logger database and ALTER permission on the dbo schema.

The SQL Server stored procedures and the GO.bat file are placed in the ..\PIPC\Piml.Web\SQL folder. The Go.bat file contains the commands that execute the deployed SQL Server scripts manually.

You can use two methods to install the necessary SQL Server scripts.

• Use Go.bat

• Execute each file within SQL Server Management Studio