Home Forums SQL Server 2005 T-SQL (SS2K5) DDL Trigger to prevent dropping of a specific table? RE: DDL Trigger to prevent dropping of a specific table?

  • I thought of this as well, but I think because this is a Development box, we have a lot of people setup as sysadmins who need access to drop/create/alter objects at will.

    Because of the natural sysadmin rights, wouldn't they basically be able to bypass all of the extra security or just undo it if they needed?

    Maybe security is the answer and I am doing overkill with the Triggers and Logging...but I had some free-time to kill and it taught me a little something about DDL trigger I guess.