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

Content with tag Schemas Rss

   Items 1 to 4 of 4   
 

Divide and Conquer

Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.  Read more...
By Phil Factor 2014/03/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 103 reads

Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)

Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.  Read more...
By Brandie Tarvin 2013/08/01 | Source: SQLServerCentral.com | Category: generate scripts
Rating: |  Discuss |   Briefcase | 3,157 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: SQLServerCentral.com | Category: schemas
Rating: |  Discuss |   Briefcase | 1,203 reads

Going From Many Schemas To One Schema

A Technique to deal with moving data from multiple schemas into one table  Read more...
By Timothy A Wiseman 2010/08/09 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 6,294 reads
   Items 1 to 4 of 4   
 
Tags
audit (1)    
database weekly (1)    
ddl_events (1)    
development (1)    
drop constraint (1)    
editorial (1)    
etl (1)    
eventnotification (1)    
events (1)    
generate scripts (1)    
notifications (1)    
sql server 2008 (1)    
sql server 2008 r2 (1)    
t-sql (1)