Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DDL trigger Rss

   Items 1 to 5 of 5   
 

Block altering indexed views.

Altering an indexed view will drop all indexes on it without warning, even if nothing is changed. This will prevent accidental alters. Script is divided into 4 parts, included testing and cleanup scripts.  Read more...
By Dennis Post 2015/09/01 | Source: SQLServerCentral.com | Category: alter index
Rating: |  Discuss |   Briefcase | 883 reads

Add user with DDL Trigger

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.  Read more...
By Teshome Asfaw 2015/03/12 | Source: SQLServerCentral.com | Category: ddl trigger
Rating: |  Discuss |   Briefcase | 1,249 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
Rating: |  Discuss |   Briefcase | 6,071 reads

Add user with DDL Trigger

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.  Read more...
By Teshome Asfaw 2015/03/12 | Source: SQLServerCentral.com | Category: ddl trigger
Rating: |  Discuss |   Briefcase | 1,249 reads

A DDL Auditing Solution

An article discussing DDL Auditing. Learn how to track schema changes that occur in your database, enabling you to see who changed what and when. Free GUI tool included.  Read more...
By David Wiseman 2012/04/19 | Source: SQLServerCentral.com | Category: ddl auditing
Rating: |  Discuss |   Briefcase | 2,258 reads
   Items 1 to 5 of 5   
 
Tags
alter index (1)    
changes (1)    
ddl auditing (1)    
ddl event (1)    
event notifications (1)    
indexed views (1)    
indexing (1)    
revert (1)    
review (1)    
source code (1)    
stored procedures (1)    
trigger (1)    
version control systems (vcs) (1)