Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

DDL trigger Expand / Collapse
Author
Message
Posted Wednesday, January 18, 2012 7:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 1, 2015 6:09 AM
Points: 2,891, Visits: 3,889
SQL Kiwi (1/18/2012)
The BOL entry for sys.all_objects says:

"Shows the UNION of all schema-scoped user-defined objects and system objects."

Server-scoped DDL triggers are not schema-scoped.

Thanks, that makes sense.


Best Regards,
Chris Büttner
Post #1237943
Posted Wednesday, January 18, 2012 7:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, June 23, 2016 7:26 AM
Points: 3,071, Visits: 1,123
Maybe I misread the question...probably, but I found this on TechNet and still got the answer wrong. Oh well, learned another one the hard way :)

Server-scoped DDL triggers are stored as objects in the master database. However, you can obtain information about server-scoped DDL triggers by querying the sys.server_triggers catalog view in any database context.
Post #1237961
Posted Wednesday, January 18, 2012 8:13 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 1,768, Visits: 2,475
I got it right for the "wrong" reason: I reasoned that 2 had to be false, because nothing is stored in a view. A view is by definition a mechanism to access data stored elsewhere.
Post #1238014
Posted Wednesday, January 18, 2012 8:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 5:23 AM
Points: 1,641, Visits: 982
My only disappointment is that 49% have got this right!
I was hoping for less.
Post #1238032
Posted Wednesday, January 18, 2012 8:27 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 19, 2015 5:35 AM
Points: 700, Visits: 466
sknox (1/18/2012)
I got it right for the "wrong" reason: I reasoned that 2 had to be false, because nothing is stored in a view. A view is by definition a mechanism to access data stored elsewhere.


Well, Idexed views are stored in the db. Can't blame you for using this reasoning, though.


---------------
Mel.
Post #1238033
Posted Wednesday, January 18, 2012 8:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks for the question
Post #1238039
Posted Wednesday, January 18, 2012 8:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 21, 2016 9:49 AM
Points: 1,107, Visits: 2,114
BarbW (1/18/2012)
Maybe I misread the question...probably, but I found this on TechNet and still got the answer wrong. Oh well, learned another one the hard way :)

Server-scoped DDL triggers are stored as objects in the master database. However, you can obtain information about server-scoped DDL triggers by querying the sys.server_triggers catalog view in any database context.


"Which of these statements is true?

Server-scoped DDL triggers are stored as objects in the [master] database.
Server-scoped DDL triggers are stored in the 'sys.triggers' catalog view in the [master] database."

THe view you mention is sys.server_triggers, not sys.triggers.
Post #1238047
Posted Wednesday, January 18, 2012 9:24 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 4,021, Visits: 2,282
Thanks for the question
Post #1238099
Posted Wednesday, January 18, 2012 9:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:10 PM
Points: 5,228, Visits: 4,399
Thanks for the question, Dan!
Post #1238105
Posted Wednesday, January 18, 2012 9:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 14, 2016 1:11 PM
Points: 1,642, Visits: 2,035
sknox (1/18/2012)
I got it right for the "wrong" reason: I reasoned that 2 had to be false, because nothing is stored in a view. A view is by definition a mechanism to access data stored elsewhere.


I used the same reasoning. I probably would have used "viewed" instead of "stored" but at least it's not a wording choice that makes it more likely for people to get it wrong.

Thanks for the question, I learned something even though I got it right.
Post #1238106
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse