Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Use Trigger on table SYSOBJECTS...

Posted on 1998-10-30
3
Medium Priority
?
518 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 300 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

722 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