• 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