Documentation

[MichelDW]

Hi

I'm creating some software for a big company and we are working against time (who isn't)

The problem is that the database is changing everyday and i, or other people of my team) is/are loosing a lot of time keeping the database information up-2-date.

Is their anyone who has a tool or an idea to automate this work, because i want to concentrate on the programming and analysing and not on writting database documentation !
(Or customers needs a complete database document when the software is going live)

Michel - NetInvent

 

[SQLDenis]

For diagrams use Visio or Erwin and reverse engineer the DB
Do you have to supply source code for stored procedures?
use sp_helptext for that (It will be always the latest when you run it)



“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/