How to insert trigger ... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

How to insert trigger ...

Author

Topic

vinko
Starting Member

1 Post

Posted - 2002-11-19 : 18:09:41

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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-11-19 : 18:23:49

DO NOT MODIFY SYSTEM TABLES, EVER!

You cannot put triggers on system tables, and you risk ruining your SQL Server by updating or inserting data into them without using the standard methods (CREATE TABLE/VIEW/PROCEDURE, etc.) See these for more details on what can happen if you try:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12672
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11903
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=8898
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14295
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=20983
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11057
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=20543
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16410
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19309

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources