Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag trigger Rss

   Items 1 to 4 of 4   
 

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 2013/09/04 | Source: SQLServerCentral.com | Category: ddl trigger
Rating: |  Discuss |   Briefcase | 589 reads

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 6,902 reads

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.  Read more...
By Larry Schmidt 2012/12/17 | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 966 reads

Constraint Event Order

By Pezhman Parsaee 2012/08/09 | Category: trigger
Rating: (not yet rated) |  Discuss |   Briefcase | 2,346 reads
   Items 1 to 4 of 4   
 
Tags
check constraint (1)    
ddl trigger (1)    
history (1)    
read only (1)    
table (1)    
update (1)