Post reply

Documentation

  • July 13, 2012 at 12:13 pm

    #272560

    Does anyone have a good tool to document an entire sql server, server settings, databases, mdf/ldf file locations, etc. ?

    Scripts?

    DMVs?

    Any suggestions will be appreciated.

    thx!

  • July 13, 2012 at 12:36 pm

    #1512683

    Check out Redgate software

    http://www.red-gate.com/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 13, 2012 at 1:21 pm

    #1512699

    there's a nice anonymous Script submission someone put together to help document a database by generating an html document here on SQL Server Central

    Comprehensive HTML Database Documentation [/url]

    i enhanced it a bit a long time ago, and a copy of those changes are here:

    db_documentation_enhanced.txt

    and a more enhanced version that includes the CREATE TABLE/VIEW/PROC/FUNCTIONS definitions here:

    sp_dbDocumentation.txt

    and here's an example of my master database's documentation off of my dev machine so you can see what it looks like:

    DEV223_master.html

    which looks like this, but goes on for all the objects:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply