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

Content with tags T-SQL, scripting Rss

   Items 1 to 3 of 3   
 

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,537 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,545 reads

Script Table or View structure

This code will let you script a Table or Views structure for source control.   Read more...
By Pratap Prabhu 2010/02/02 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 2,096 reads
   Items 1 to 3 of 3   
 
Tags
administration (1)    
automation (1)    
create index (1)    
databases (1)    
dynamic sql (1)    
grant (1)    
indexing (1)    
logins (1)    
permissions (1)    
role (1)    
script (1)    
security (1)    
sql server 7 (1)    
structure (1)    
user (1)