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?
***Updated by Moderator: Marissa to update topic categories***
Pega has started support varbinary(max) since 7.2 )fresh install) following MSSQL suggestions as image type is deprecated. If your pega version is >=7.2 and PRPC supported MSSQL versions (>=2008r2), it's safe to convert existing blob column type from image to varbinary(max) and create after trigger.