http://www.sqlmag.com/authors/author/author/5320770/rsscomment/5320770en-USFri, 25 May 2012 11:05:48 GMTFri, 25 May 2012 11:05:48 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorThu, 02 Dec 2010 06:52:37 GMT
Thank you for your time and sharing this with all of us. I know it takes a good bit of time to come up with tools like these as well as type up how to use it.]]>christopherThu, 02 Dec 2010 06:52:37 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorWed, 24 Nov 2010 09:49:08 GMT
NOTE: As mentioned by one of the posters above, the "Download the Code" archive on this site may be missing some of the stored procedures and the SSRS report described in this article. You can download these items here:

http://www.zgrafsoftware.com/resume/PUBLICATIONS/BuildingDynamicDataDictionaries.zip

Thank you,

John Jakob
john_jakob@hotmail.com
]]>JakobWed, 24 Nov 2010 09:49:08 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorThu, 18 Nov 2010 15:06:08 GMT
Where’s the code for the report?]]>FraserThu, 18 Nov 2010 15:06:08 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorThu, 18 Nov 2010 12:46:39 GMT
>> Where’s the code for the report?
>> Fraser 11/18/2010 11:21:58 AM

Hi Fraser,
Looks like the editors didn’t include my SSRS report code in the "Download the Code" archive above.
If you send me an e-mail, I will mail you a ZIP file that contains the report code.
Thank you,
John Jakob
john_jakob@hotmail.com

]]>JakobThu, 18 Nov 2010 12:46:39 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorThu, 18 Nov 2010 12:31:06 GMT
>> Where’s the code for the report?
>> Fraser 11/18/2010 11:21:58 AM

Hi Fraser,
Looks like the editors didn’t include my SSRS report code in the "Download the Code" archive above.
If you send me an e-mail, I will mail you a ZIP file that contains the report code.
Thank you,
John Jakob
john_jakob@hotmail.com

]]>JakobThu, 18 Nov 2010 12:31:06 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorThu, 18 Nov 2010 11:21:58 GMT
Where’s the code for the report?]]>FraserThu, 18 Nov 2010 11:21:58 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorMon, 25 Oct 2010 13:30:46 GMT
I just completed a very similar project.
We have a set of scripts that act as the definition (These databases get built much like c# files get built).
Our innovation was to require comments in the CREATE TABLE scripts. These immediately precede any column or table names and start with "---".

The same way xml documentation in .net code requires comments that start with "///"
]]>SwartMon, 25 Oct 2010 13:30:46 GMThttp://www.sqlmag.com/article/sql-server/building-dynamic-data-dictionaries#commentsAnchorhttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchorWed, 31 Jan 2007 09:15:45 GMT
Author’s Note [1.31.2007]: I’ve updated the code a bit to avoid scripting out system tables, procs, views, and UDFs in SQL 2005. Updated code available here: http://www.zgrafsoftware.com/SchemaCollector John Jakob john_jakob@kindredhealthcare.com]]>JohnWed, 31 Jan 2007 09:15:45 GMThttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchorhttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchorThu, 25 Jan 2007 09:14:51 GMT
Thanks - we’ll get the code posted today.]]>DianaThu, 25 Jan 2007 09:14:51 GMThttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchorhttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchorWed, 24 Jan 2007 19:26:48 GMT
Where is the .zip download?]]>RICHARDWed, 24 Jan 2007 19:26:48 GMThttp://www.sqlmag.com/article/auditing/sql-server-2005-schema-scripting#commentsAnchor