[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

trigger on sysobjects

Posted on 1998-04-20
1
Medium Priority
?
759 Views
Last Modified: 2012-08-14
the system allows creation of triggers on sysobjects table. this works fine when one does changes to the sysobjects table after setting 'allow updates' option on. however, the trigger does not fire, when let's say you compile a procedure, which also goes through dropping and recreating a procedure. i am wondering about the difference in two scenarios.
0
Comment
Question by:sajalk
1 Comment
 
LVL 10

Accepted Solution

by:
bret earned 400 total points
ID: 1091332
The difference, I think, would be that triggers are designed to fire on certain commands:  insert, update, and delete.  Drop procedures and create procedure are not one of those commands,
so the trigger doesn't fire.

Actually, I'm a bit surprised that they fire at all for system tables, as in the 4.2 version triggers could be created on system tables but would never fire (and this was documented).
But it sounds like Microsoft has enhanced them somewhat.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

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 …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

868 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