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: | Category: sql server
Rating: |  Discuss |   Briefcase | 2,632 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 Shivaram Challa 2008/10/08 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,088 reads
   Items 1 to 2 of 2   
constraints (1)    
role (1)    
security (1)    
sql server (1)