How to insert trigger ...

vinko · #1 11-19-2002, 11:10 AM

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

bamcorp · #2 11-21-2002, 04:18 PM

Bad idea. Why?

sjimmo · #3 11-26-2002, 01:18 PM

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.