> Hi,
>
> I'm new to SQL Server.  I've been using Access for a number of years.  I'm
> having trouble figuring out how to document the database I've created in SQL
> Server.  Is there nothing, in SQL Server, like the "Database Documenter" in
> Access?
>
> Thanks.

"Aaron Bertrand [SQL Server MVP]" wrote:

> Not really.  You can create diagrams but I find it an exercise in futility.
> Plenty of 3rd party tools though.  For example:
>
> http://www.red-gate.com/products/SQL_Doc/index.htm
>
> http://www.apexsql.com/sql_tools_doc.asp
>
>
> On 6/12/09 10:19 AM, in article
> 250DFCD3-CEF6-4788-973E-3BE251D79***@microsoft.com, "NeilShore"
> <NeilSh***@discussions.microsoft.com> wrote:
>
> > Hi,
> >
> > I'm new to SQL Server.  I've been using Access for a number of years.  I'm
> > having trouble figuring out how to document the database I've created in SQL
> > Server.  Is there nothing, in SQL Server, like the "Database Documenter" in
> > Access?
> >
> > Thanks.
>
>

"Aaron Bertrand [SQL Server MVP]" wrote:

> > However, it seems strange that Access should have a "more" sophisticated
> > tool for documenting databases then the ³more² sophisticated database server.
>
> Access is an application, SQL Server is a server.  As Access is much
> simpler, it is relatively easy to create such a feature that ships in the
> box.  SQL Server is much more complex, and because there are already very
> capable 3rd party tools out there that can do this, I would rather they
> spend their efforts making the server better, than trying to reproduce 3rd
> party efforts.
>
> This is like saying that some recipe program is better at cataloging recipes
> than Windows.  :-)
>
>

"John Bell" wrote:

>
> "NeilShore" <NeilSh***@discussions.microsoft.com> wrote in message
> news:250DFCD3-CEF6-4788-973E-3BE251D79D92@microsoft.com...
> > Hi,
> >
> > I'm new to SQL Server.  I've been using Access for a number of years.  I'm
> > having trouble figuring out how to document the database I've created in
> > SQL
> > Server.  Is there nothing, in SQL Server, like the "Database Documenter"
> > in
> > Access?
> >
> > Thanks.
>
> You can also use Visio to reverse engineer the database and produce reports
> on the model. Other modelling tools will also do that.
>
> John
>
>

"Eric Isaacs" wrote:

> Here's a script that does a pretty good job of creating an HTML data
> dictionary for SQL 2005.  Hey, it's free...
>
> http://www.developer.com/img/2007/05/data_dictionary.sql
>
> Eric Isaacs
> J Street Technology, Inc.
> http://www.jstreettech.com
>