Recreating the UDFs

After the upgrade, recreate the required UDFs to restore the Database Protector functionality.

To re-create the UDFs:

  1. Log in to the database server as the user that has the permissions.

  2. Navigate to the C:\Program Files\Protegrity\Database Protector\sqlserver\sqlscripts directory.

  3. To register the assembly, execute the CreateAssembly.sql script.

  4. To create the UDFs, execute the CreateFunctions.sql script.


Last modified : May 21, 2026