Create the IN_DB_UTIL Package - Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external - Perceptive-Content/Perceptive-Content-Database-IN_DB_UTIL-Package-5.0-for-SQL-Server/Foundation-24.1/Perceptive-Content-Database-IN_DB_UTIL-Package-5.0-for-SQL-Server/Create-the-IN_DB_UTIL-Package - 2024-04-02

Execute the following script to create the IN_DB_UTIL database package.

-- Name of Database 
:setvar v_database_name 'INOW' 

Complete one of the following options:

• In SSMS, execute the following script.
  Note: You must execute this script with SQLCMD Mode enabled.

  To enable SQLCMD mode from the SSMS toolbar, click Query and then select SQLCMD Mode.

  PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql 

• Using the sqlcmd utility, execute the following script.
  Note: You must establish your connection using the -l option to set the QUOTED IDENTIFIER connection option to ON. The default is OFF.

  sqlcmd -I -i "PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql" 

Example

set SQLCMDSERVER=[protocol:]server[\instance_name][,port] 
set SQLCMDDBNAME=[DBNAME] 
sqlcmd -I -i "PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql"