<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Dan Hess
»
DDL trigger
30 posts, Page 2 of 3
««
1
2
3
»»
DDL trigger
Rate Topic
Display Mode
Topic Options
Author
Message
Christian Buettner-167247
Christian Buettner-167247
Posted Wednesday, January 18, 2012 7:13 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:36 AM
Points: 2,522,
Visits: 3,616
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
BarbW
BarbW
Posted Wednesday, January 18, 2012 7:36 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:22 AM
Points: 2,035,
Visits: 929
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
sknox
sknox
Posted Wednesday, January 18, 2012 8:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 1,038,
Visits: 1,355
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
paul s-306273
paul s-306273
Posted Wednesday, January 18, 2012 8:27 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,158,
Visits: 642
My only disappointment is that 49% have got this right!
I was hoping for less.
Post #1238032
SqlMel
SqlMel
Posted Wednesday, January 18, 2012 8:27 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, July 19, 2012 11:22 AM
Points: 347,
Visits: 121
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.
It's no fun if it's not complicated.
Post #1238033
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Wednesday, January 18, 2012 8:40 AM
Ten 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
jeff.mason
jeff.mason
Posted Wednesday, January 18, 2012 8:45 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, May 06, 2013 6:51 AM
Points: 989,
Visits: 1,790
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
KWymore
KWymore
Posted Wednesday, January 18, 2012 9:24 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:20 PM
Points: 2,573,
Visits: 1,531
Thanks for the question
Post #1238099
Revenant
Revenant
Posted Wednesday, January 18, 2012 9:28 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 10:44 AM
Points: 3,452,
Visits: 2,527
Thanks for the question, Dan!
Post #1238105
cfradenburg
cfradenburg
Posted Wednesday, January 18, 2012 9:29 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 AM
Points: 1,555,
Visits: 1,925
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 »
30 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
