Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

Use Trigger on table SYSOBJECTS...

I need to create a trigger (or something else) that updates a table if a certain table is added to the database. I've created an insert-trigger on the SYSOBJECTS-table in the database. This would helpup the problem but it doesn't seem to trigger at all. Is there something that I've missed, or isn't it possible to set triggers on the sys-tables?
0
tsp
Asked:
tsp
  • 2
1 Solution
 
Victor SpiridonovCommented:
It's a 'feature' of SQL Server. Trigger on sysobject doesn't work.
0
 
tspAuthor Commented:
OK! But do u have a solution to my problem?

What can I do to update a table when an object is added to the database?
0
 
Victor SpiridonovCommented:
You can't trigger this process automatically when new object added. You can only create a SQL Executive task, that will check for new objects at certain intervals.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now