<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 1 of 3
1
2
3
»
»»
DDL trigger
Rate Topic
Display Mode
Topic Options
Author
Message
SQLDCH
SQLDCH
Posted Tuesday, January 17, 2012 10:03 PM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:19 AM
Points: 891,
Visits: 2,266
Comments posted to this topic are about the item
DDL trigger
----------------------------------------------------------------------------
My LinkedIn profile -
LinkedIn
Sacramento SQL Server users group -
http://sac.sqlpass.org
My blog -
http://www.expressnetsolutions.com/sqldch
Follow me on Twitter -
@SQLDCH
----------------------------------------------------------------------------
Yeah, well...The Dude abides.
Post #1237661
SQLRNNR
SQLRNNR
Posted Tuesday, January 17, 2012 11:55 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
Thanks for the ?
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1237684
Christian Buettner-167247
Christian Buettner-167247
Posted Wednesday, January 18, 2012 1:45 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:12 AM
Points: 2,526,
Visits: 3,620
I am not sure I understand the explanation.
I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an "object" in the master database. But sys.all_objects does not contain the server scoped triggers.
Why is that?
Best Regards,
Chris Büttner
Post #1237733
Paul White
Paul White
Posted Wednesday, January 18, 2012 3:01 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 5:01 PM
Points: 10,990,
Visits: 10,545
Christian Buettner-167247 (1/18/2012)
I am not sure I understand the explanation.
I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an "object" in the master database. But sys.all_objects does not contain the server scoped triggers.
Why is that?
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.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1237780
DugyC
DugyC
Posted Wednesday, January 18, 2012 3:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:25 AM
Points: 1,165,
Visits: 731
Another lesson not learned about reading the question and answers carefully.
You can obtain info by querying sys.triggers but they are only stored as objects on the master database. I got too excited and chose true/true... oops!
I'll call this karma...
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1237784
SqlMel
SqlMel
Posted Wednesday, January 18, 2012 5:06 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, July 19, 2012 11:22 AM
Points: 347,
Visits: 121
Good question.
---------------
Mel.
It's no fun if it's not complicated.
Post #1237866
L' Eomot Inversé
L' Eomot Inversé
Posted Wednesday, January 18, 2012 5:14 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 7,112,
Visits: 7,188
Good question. Nice explanation.
Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1237872
Mike Is Here
Mike Is Here
Posted Wednesday, January 18, 2012 5:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 1,331,
Visits: 433
Good thing MSDN is not blacked out.
Post #1237898
Cliff Jones
Cliff Jones
Posted Wednesday, January 18, 2012 6:53 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 3,400,
Visits: 3,411
For some reason I thought the question was about database scoped triggers even though it clearly says server scoped. Brain not fully engaged yet. Good question.
Post #1237928
Dana Medley
Dana Medley
Posted Wednesday, January 18, 2012 7:01 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 1,356,
Visits: 874
Great question.
I guess it's just a little too early for the brain to be attempting to operate 100%. That's what I get for attempting to answer without some caffeine pumping yet.
Oh no, we're toast!
I've got this. *Keyboard clatter*
Woah, how'd you do that?
I'm a DBA...Booyah
Yeah, uh huh, you know what it is. Everything I do, I do it big
Post #1237934
« Prev Topic
|
Next Topic »
30 posts, Page 1 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.
