Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag DDL Rss

   Items 1 to 13 of 13   

Alter all/specific columns by double dynamic SQL

The script uses dynamic SQL twice first to get the detail about the database structure and create ddl out of it second to execute each DDL created  Read more...
By Ashish Shevale 2015/11/03 | Source: | Category: alter
Rating: |  Discuss |   Briefcase | 881 reads

NONclustered 2 clustered

By Carlo Romagnano 2015/04/20 | Category: ddl
Rating: (not yet rated) |  Discuss |   Briefcase | 1,701 reads


By Hardik Doshi 2014/08/01 | Category: synonym
Rating: (not yet rated) |  Discuss |   Briefcase | 1,803 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: | Category: sql server
Rating: |  Discuss |   Briefcase | 2,637 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: | Category: editorial
Rating: |  Discuss |   Briefcase | 130 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,480 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,860 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: | Category: ddl
Rating: |  Discuss |   Briefcase | 2,149 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: | Category: ddl
Rating: |  Discuss |   Briefcase | 7,349 reads

DDL Rollback

By Hari Sharma 2009/10/05 | Category: rollback
Rating: (not yet rated) |  Discuss |   Briefcase | 3,938 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: | Category: auditing
Rating: |  Discuss |   Briefcase | 5,617 reads

Drop Column

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