Results 1 to 3 of 3

Thread: How to insert trigger ...

  1. 11-19-2002, 11:10 AM #1
    vinko
    vinko is offline Registered User
    Join Date
    Nov 2002
    Posts
    1

    Question 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
    Reply With Quote Reply With Quote
  2. 11-21-2002, 04:18 PM #2
    bamcorp
    bamcorp is offline Registered User
    Join Date
    Nov 2002
    Posts
    8
    Bad idea. Why?
    Reply With Quote Reply With Quote
  3. 11-26-2002, 01:18 PM #3
    sjimmo
    sjimmo is offline Registered User
    Join Date
    Nov 2002
    Location
    Chicopee, MA
    Posts
    12

    Thumbs down Update to System Tables

    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.
    Steve Jimmo
    DBA
    Sybase, MS SQL Server
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules