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

Content with tag Data Dictionary Rss

   Items 1 to 6 of 6   
 

SQL SERVER 2008 Data Dictionary

Comprehensive data dictionary for databases that use the extended properties for storing descriptions.  Read more...
By Abdullah.Khan 2014/01/22 | Source: SQLServerCentral.com | Category: data dictionary
Rating: |  Discuss |   Briefcase | 5,013 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...
By Derek Colley 2012/08/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,025 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 5,338 reads

SQL SERVER 2008 Data Dictionary

Comprehensive data dictionary for databases that use the extended properties for storing descriptions.  Read more...
By Abdullah.Khan 2014/01/22 | Source: SQLServerCentral.com | Category: data dictionary
Rating: |  Discuss |   Briefcase | 5,013 reads

Script to build a SQL Server Data Dictionary and report with Microsoft Excel

There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?  Read more...
By Additional Articles 2008/12/09 | Source: MSSQLTips.com | Category: excel
Rating:  Rate this |   Briefcase | 4,331 reads

Building a SQL Server Data Dictionary with the Extended Properties and Third Party Tools

When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?  Read more...
By Additional Articles 2008/11/13 | Source: MSSQLTips.com | Category: documenting code
Rating:  Rate this |   Briefcase | 2,790 reads
   Items 1 to 6 of 6   
 
Tags
extended properties (2)    
amo (1)    
bi (1)    
c# (1)    
cube (1)    
documenting code (1)    
excel (1)    
integration services (ssis) (1)    
list (1)    
parameter (1)    
sp_sproc_columns (1)    
stored procedure (1)    
t-sql (1)    
xml (1)    
xmla (1)    
xquery (1)