Solved

Use Trigger on table SYSOBJECTS...

Posted on 1998-10-30
3
500 Views
Last Modified: 2012-06-27
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
Comment
Question by:tsp
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 100 total points
ID: 1090898
It's a 'feature' of SQL Server. Trigger on sysobject doesn't work.
0
 

Author Comment

by:tsp
ID: 1090899
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
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090900
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question