I want to update DBQLogTBL QueryText column to NULL value.
Presently the value was set to 10000 which is occupying space.
I have replaced query logging to change it to 0. We are using DBQLSQLTBL for query so don't need query here.
However I want to change existing values to NULL.
I am using DBC user still I cannot update the DBQLogTbl querytext column.
You don't need to update the DBQL tables in dbc because there should be a daily housekeeping process moving the data to a history table where you got all rights.