I need to Automatically Update the system Catalogues on 2008.
Basically I want Automatically remove the extended properties for a given table,
Now I know this can't be done, is there another way around this?
Exec sp_configure 'allow updates', 1 Reconfigure with override
waitfor delay '00:00:01'
DELETE
from sys.extended_properties
WHERE major_id =446624634
Exec sp_configure 'allow updates', 0 Reconfigure with override