Results 1 to 15 of 15
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Save As Template?

    In Enterprise Manager when I bring up Trigger Properties there is an active button titled "Save as Template". But when I switch to an existing trigger the button is disabled. Oddly, the Help file for the dialog box doesn't even mention this button.

    Anybody know what this does, how it works, or why it would be usefull? Any references to The Holy Book would be helpfull.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It looks like an EM trigger template...of which you can have 1...since mine is now hosed across several servers/instances....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can only have one template across all tables and databases for Updates, Inserts, and Deletes? How useless. No wonder they didn't bother mentioning it in Books Online.

    Anybody out there ever modified the trigger template?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Hell....go in and try it....it's not a database object....

    What's Em good for....absolutley nothin...say it again....War, what it good for, absoultley nothin...say it again...

    oops......gotta watch those flash backs.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Yup, I just hosed mine (good thing I try not to use triggers, needless to say create them using EM )

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Re: Save As Template?

    Originally posted by blindman
    In Enterprise Manager when I bring up Trigger Properties there is an active button titled "Save as Template". But when I switch to an existing trigger the button is disabled. Oddly, the Help file for the dialog box doesn't even mention this button.

    Anybody know what this does, how it works, or why it would be usefull? Any references to The Holy Book would be helpfull.
    Hey BM, since when did you start using EM. I acknowledge , the holy book does not cover EM very well ...

    But why to use EM when you can do the same using QA ... did you know ... QA has a save as template option as well ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    QA - the Holy Tool !!!

  8. #8
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Save As Template?

    Originally posted by Enigma
    Hey BM, since when did you start using EM. I acknowledge , the holy book does not cover EM very well ...

    But why to use EM when you can do the same using QA ... did you know ... QA has a save as template option as well ???
    Nice shoot...

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Don't make me get up out of this chair.....


    And yes...I love using QA templates...

    anyone seen codesmith though?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Well in my view :-
    EM --- SQL for Dummies
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  11. #11
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Originally posted by Brett Kaiser
    Don't make me get up out of this chair.....


    And yes...I love using QA templates...

    anyone seen codesmith though?
    [Brett Falls trying to get out of his chair]

    You are glued to that DBA's chair BK .. dont try to get up

    [/Brett Falls trying to get out of his chair]

    Codesmith ... hmm .. not used it till now .. will try do download and use it once I get out from this Client Office ... damn ... here I need permission to install anyting on my PC.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I frequently use EM for tweaking existing code.

    I like EM, after especially after having had to use Sybase's management interface years ago. Now that was crappy.

    ...and for that matter I use triggers when they make the coding easier or more robust as well.
    Last edited by blindman; 01-29-04 at 15:48.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blindman
    I frequently use EM for tweaking existing code.

    I like EM, after especially after having had to use Sybase's management interface years ago. Now that was crappy...

    Yeah? Try SQLPlus for Oracle...

    Better yet, use SPUFI on the maijnframe.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You think that's tough? Back in my day we created enterprise-wide datawarehouse solutions using nothing but Windows Cardfile, Calculator, and a handfull of Post-It notes!

    ...and we LIKED 'em, Sonny!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  15. #15
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    To use or not to use, - personal preference, not a dogma

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •