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

Content with tag DDL Rss

   Items 1 to 11 of 11   
 

Synonym

By Hardik Doshi 2014/08/01 | Category: synonym
Rating: (not yet rated) |  Discuss |   Briefcase | 1,714 reads

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

When Windows don’t provide illumination

Microsoft through its various GUIs tries hard to "protect" users from SQL, but Phil Factor argues that we don't need protection from code. We just need a better way to "document" the syntax.  Read more...
By Phil Factor 2013/06/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 129 reads

Auditing DDL Changes in SQL Server databases

Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.  Read more...
By Additional Articles 2011/10/20 | Source: SimpleTalk | Category: ddl
Rating: (not yet rated)  Rate this |   Briefcase | 2,277 reads

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task

The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).  Read more...
By Additional Articles 2011/09/07 | Source: Database Journal | Category: ddl
Rating: (not yet rated)  Rate this |   Briefcase | 1,774 reads

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...
By Rich Yarger 2011/03/14 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 2,097 reads

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,238 reads

DDL Rollback

By Hari Sharma 2009/10/05 | Category: rollback
Rating: (not yet rated) |  Discuss |   Briefcase | 3,923 reads

Auditing with SQL Profiler

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...
By Thom Bolin 2009/07/16 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,596 reads

Drop Column

Drop Column after checking regular constraints and dropping these constraints   Read more...
By Srinivas Annaswamy 2009/03/23 | Source: SQLServerCentral.com | Category: drop column
Rating: |  Discuss |   Briefcase | 896 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 11 of 11   
 
Tags
t-sql (3)    
administration (2)    
auditing (2)    
sql server 2005 (2)    
constraints (1)    
database trigger (1)    
ddl triggers (1)    
dml (1)    
dml tracking (1)    
drop column (1)    
editorial (1)    
integration services (ssis) (1)    
profiler (1)    
role (1)    
rollback (1)    
security (1)    
server trigger (1)    
sql compare (1)    
sql server (1)    
sql server 2008 (1)    
synonym (1)