top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How do we create trigger on system tables? What can be the reasons to create trigger on system tables?

+1 vote
306 views
How do we create trigger on system tables? What can be the reasons to create trigger on system tables?
posted Nov 22, 2014 by Vrije Mani Upadhyay

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Before create a trigger, consider that:
The CREATE TRIGGER statement must be the first statement in the batch. All other statements that follow in that batch are interpreted as part of the definition of the CREATE TRIGGER statement.

Permission to create triggers defaults to the table owner, who cannot transfer it to other users.

Triggers are database objects, and their names must follow the rules for identifiers.

For More InformationPlz follow this link:
http://technet.microsoft.com/en-us/library/aa214593(v=sql.80).aspx

answer Nov 24, 2014 by Devyani
...