How to insert trigger ...

Hi



How to insert trigger into system table SYSOBJECTS from an other table.
I try with INSERT INTO SYSOBJECTS SELECT * FROM TABLE but mssql 2000(msde) return error msg 259 (Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.)



Tnk

Bad idea. Why?

First, why do you want to have a trigger make modifications to a system table?

You must talk to your DBA or systems admin person in order to allow the systems tables to be set to allow updates. If I was your DBA, the answer would be a definite no.