Home Forums Article Discussions Article Discussions by Author Discuss content posted by Subhash Chandra Prevent accidental DB drop\delete RE: Prevent accidental DB drop\delete

  • October 24, 2018 at 4:58 pm

    #2011040

    Sue_H - Wednesday, October 24, 2018 11:52 AM

    Subhash Chandra - Wednesday, October 24, 2018 9:46 AM

    Comments posted to this topic are about the item Prevent accidental DB drop\delete

    Looks like Lowell's code here - same format, same comments, etc:
    DDL trigger to prevent drop of a particular database

    with a couple really little changes - and one changed incorrectly. When you changed sysname, it should be nvarchar(128) not varchar(128).
    I'd stick with Lowell's example.

    Sue

    That and stop posting stuff as if it were your own when it's not.  I understand that there's only a certain number of ways to write code but, like Sue said, the comments and even the spacing of the code are identical to Lowell's.  There's only one way that can happen.

    --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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)