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

Content with tag REVERT Rss

   Items 1 to 3 of 3   
 

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: SQLServerCentral.com | Category: version tracking
Rating: |  Discuss |   Briefcase | 4,931 reads

Alas Poor Snapshot, I Knew Him Well

By Andy Warren 2014/03/20 | Category: snapshot
Rating: (not yet rated) |  Discuss |   Briefcase | 2,184 reads

Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005

In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?  Read more...
By Additional Articles 2009/01/15 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 2,466 reads
   Items 1 to 3 of 3   
 
Tags
changes (1)    
ddl trigger (1)    
editions (1)    
execute as (1)    
indexing (1)    
review (1)    
security (1)    
snapshot (1)    
source code (1)    
stored procedures (1)    
t-sql (1)    
version control (1)    
version tracking (1)