Post reply

Alternative for Policy Management in SQL Server

  • March 27, 2014 at 9:19 pm

    #289832

    Comments posted to this topic are about the item Alternative for Policy Management in SQL Server

  • March 28, 2014 at 5:57 am

    #1701045

    The trigger, if it were the only DDL trigger in place, would only create a minor nuisance for someone who really wanted to get an illegal name into place. Consider this move:

    CREATE PROC dbo.ispTest AS SET NOCOUNT ON;

    EXEC sp_rename 'dbo.ispTest', 'Test'

    You could add a trigger that fired on RENAME as well but it would need to inspect EVENTDATA() and the catalog metadata in a different way than is the CREATE_PROCEDURE trigger.

    Neat technique to think about for this and other uses as well to keep the environment consistent.

    Thanks for sharing.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 29, 2015 at 10:38 am

    #1808836

    Thanks for the script.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply