Post reply

preventing an accidental execution of a alter SPROC statement

  • June 23, 2006 at 8:19 am

    #114144

    What is the best way of preventing an accidental execution of a alter SPROC statatement against a running version of a database.  Is there a kind of locking mechanism that I can use?

  • June 26, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 28, 2006 at 6:34 am

    #646343

    I'm not sure but you might be able to use DDL triggers in SQL Server 2005... recommend that you read up about them. If you can't use 'em to prevent proc alterations you can at least get notifications about 'em

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

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