Documents SQL Server 2005 and 2008 databases.
Moderators: JonathanWatts, David Atkinson, Michelle Taylor
I have already generated a documentation for a sql server 2005 database using sql doc. I have added description to tables(250+) and variables.
Now we have added couple of tables and variables to same database and want to generate the word documentation.
do I need to add the description for all tables once again or is there any other way to acheive this?
Thanks for your help.
- Posts: 1
- Joined: Tue Feb 01, 2011 4:30 pm
The documentation you already entered should still be there. When you enter descriptions against objects using SQL Doc, the information is stored in the database as extended properties using MS_Description - so you only need to add information for the new objects.
The only time this won't happen is if you have restored the database using a backup that was taken prior to it being documented the first time round, as this will remove everything you entered.
- Posts: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
Return to SQL Doc 2
Who is online
Users browsing this forum: No registered users and 0 guests