Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Trigger Trivia Expand / Collapse
Author
Message
Posted Monday, November 12, 2007 9:38 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Comments posted to this topic are about the item Trigger Trivia

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #421316
Posted Tuesday, November 13, 2007 12:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 37,104, Visits: 31,658
Good synopsis of uses, Andy!

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #421374
Posted Tuesday, November 13, 2007 3:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 6, 2009 10:58 AM
Points: 1, Visits: 5
Short but very informative. Thanks!
Post #421434
Posted Tuesday, November 13, 2007 4:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 7, 2012 12:30 PM
Points: 37, Visits: 136
By chance the disable trigger hint came just when I needed it. Thanks for the nice synopsis you won't find somewhere else.
Post #421468
Posted Tuesday, November 13, 2007 5:16 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 4:18 AM
Points: 798, Visits: 1,003
if you need all trigers disabled, you can specify 'all' instead of triggername. i found it useful
Post #421487
Posted Tuesday, November 13, 2007 5:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 5,369, Visits: 9,913
Great article, Andy - thanks. Can I just ask a question about Tip#4?

If you want to really make sure no resultsets occur you can use spconfigure to set disallow results from triggers to off.


Is this a typo and did you mean to say "on"? Also, if you do this, you'll get an error message every time a trigger tries to return a result set and so you'd need to add some error-handling code to your trigger and/or application.

John
Post #421488
Posted Tuesday, November 13, 2007 5:38 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
John, you're right, it should be ON. Calling it a typo is generous!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #421507
Posted Tuesday, November 13, 2007 5:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Dragos, I don't think I knew that about ALL, thats a nice shortcut.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #421509
Posted Tuesday, November 13, 2007 6:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 17, 2010 7:46 AM
Points: 4, Visits: 32
Wow!
The tip about DDL and CLR triggers was great!

It's too bad we don't see more articles like this!
Short, Sweet, and useful!
Post #421535
Posted Tuesday, November 13, 2007 6:43 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 4:18 AM
Points: 798, Visits: 1,003
Andy, that's the one i used most times... if not always. glad if it helps
Post #421546
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse