Solved

Use Trigger on table SYSOBJECTS...

Posted on 1998-10-30
3
496 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
Comment Utility
It's a 'feature' of SQL Server. Trigger on sysobject doesn't work.
0
 

Author Comment

by:tsp
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now