• Jeff Moden - Wednesday, October 24, 2018 4:58 PM

    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.

    is there an option to flag the item itself as being a possible copy from another one? many people will only see the top link and assume it was done by the individual posting it.