Tag Info

New answers tagged


Execute DBCC CHECKTABLE or DBCC CHECKDB to set the has_unchecked_assembly_data to zero. This is documented in the SQL Server Books Online sys.tables reference.


Without more insight into the intended goal of this request, it certainly seems as though even with this immediate issue solved, the working code might not provide anything truly useful. Some concerns are: Depending on how many tables this Trigger will be placed on and/or how frequent the DML operations are, this could cause minor performance issues in the ...

Top 50 recent answers are included