Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Documentation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-24 : 08:24:22
Tammy writes "In MS Access you can Go under Tools - Analyze - Documenter and get a complete listing of tables, queries, forms. Can you do this in SQL Server?"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-02-24 : 08:38:43
Hey, the chance for a CodeSmith plug

If you get codesmith ( http://www.ericjsmith.net/codesmith/ ) and you should , you can use these templates ( http://www.ngallery.org/dbdocumenter/ ) so you can output this : http://www.ngallery.org/dbdocumenter/demo/



Damian
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-24 : 12:37:35
You can also get the information from Query Analyzer in the object browser. Just right click on the object and you can have it script out the different statements for you.

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-24 : 12:50:39
quote:
Originally posted by Merkin

Hey, the chance for a CodeSmith plug

If you get codesmith ( http://www.ericjsmith.net/codesmith/ ) and you should , you can use these templates ( http://www.ngallery.org/dbdocumenter/ ) so you can output this : http://www.ngallery.org/dbdocumenter/demo/



Damian



Do you get a commission?

And that's the best damn sql documenattion I've seen yet.



Brett

8-)
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-02-24 : 17:03:39
No commision, you can get all that for free!
I just love the product, once you get to know it you can save hours of repetative coding. You should check it out

And yes, the doco is great. Easily rivals the $$$ documentation tools.



Damian
Go to Top of Page
   

- Advertisement -