top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+1 vote
40 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...