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 11:52 am

    #2010983

    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