<div>
OK! But do u have a solution to my problem?<br />
<br />
What can I do to update a table when an object is added to the database?<br />

</div>


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?


<div>
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.<br />

</div>


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.


<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Use Trigger on table SYSOBJECTS...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.