Our DB vendor is MS SQL. We are planning to use a Database trigger to write a history to another table for compliance reasons. This DB table has a light weight BLOB column. We would use Pega way of writing history using a Rule Declare Trigger at some point in future but for now the quick way we want to adopt is use a DB trigger.

We want to set up a “after trigger” for this but MS SQL doesn’t allow an after trigger for a column with "image" data type. Since pzPVStream is defined as an "image" type, we are having this issue. My DBA suggested that we can use varbinary(max) as the data type for the BLOB column.

Before we begin to even explore that route, I wanted to check if anyone has done this before or come across this before? Will this data type be supported by Pega for this BLOB column?

Many thanks,

Ranjay

***Updated by Moderator: Marissa to update topic categories***