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 6 of 6   
 

The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...  Read more...
By Dwain Camps 2015/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,550 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,227 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,227 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,954 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 | 1,013 reads

Constraint Event Order

By Pezhman Parsaee 2012/08/09 | Category: trigger
Rating: (not yet rated) |  Discuss |   Briefcase | 2,362 reads
   Items 1 to 6 of 6   
 
Tags
check constraints (1)    
ddl trigger (1)    
history (1)    
read only (1)    
table (1)    
t-sql (1)    
update (1)