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

Content with tags Administration, DDL Rss

   Items 1 to 2 of 2   
 

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,612 reads

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.   Read more...
By Shiva Challa 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,083 reads
   Items 1 to 2 of 2   
 
Tags
constraints (1)    
role (1)    
security (1)    
sql server (1)