How to delete data in DMVs( system tables) in Microsoft Parallel Datawarehouse

101 Views Asked by At

I need to delete some of the data in a system table. Is there anything that I can do?

1

There are 1 best solutions below

2
On

You cannot delete data from DMVs, nor alter results from DMFs since they are collecting the data from sql server resource table which is unavailable to the user.

The only way to reset the data is to restart/shutdown sql server service