New procedures getting generated when not required (cmdline)

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

New procedures getting generated when not required (cmdline)

Postby CraigOttley » Thu Sep 16, 2010 12:17 pm

Hi!

I like the fact that new tables, views etc get picked up when generating the documentation via command line. How ever some areas of our Documentation are getting generated when we don't need them and it requires manual intervention in the project :(

Example:
I've got a project to just generate documentation for Tables and Views nothing else. So naturally in the project i've selected Tables and views, any new/altered tables and views get added autmatically which is fine.

What's not good is when a New/Altered Procedure, Function, User etc (Basically anything other than a table or view) is added/altered the Documentation get's generated for those as well. I didn't want those so have to go in the project(s) untick the items i don't want and re-run the process.

Anything you can suggest as i can't change the XML for the sqldoc project?
CraigOttley
 
Posts: 13
Joined: Thu Jul 15, 2010 11:50 am
Location: Newport Pagnell

Postby james.billings » Fri Sep 17, 2010 1:49 pm

Hi,

I've contacted you directly about this, so keep an eye out for our email.

Thanks!
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby james.billings » Fri Sep 17, 2010 5:42 pm

OK, currently the command line doesn't support choosing which object types to include or exclude- the project files appear to maintain a full list of objects, even where you ticked or unticked the top level item in the tree (i.e. "Table", "View" etc.)
So, when a new object is added, it seems to just get included by default.

I guess ideally we'd need an extra command-line option to allow you to define the object types to be used. I have logged a feature request for this; but I can't say when it would be likely to be implemented.
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby CraigOttley » Fri Sep 24, 2010 10:54 am

I've come up with a work around for this. I've created a user for SQL Doc and revoked all privileges except for Tables and Views :D . SQL Doc can't generate documentation for what is hasn't got access to.

Simple Example

Code: Select all
USE master
GO
GRANT VIEW ANY DEFINITION TO SQLDoc
GO
REVOKE VIEW ANY DEFINITION FROM SQLDoc
GO
[/code]
CraigOttley
 
Posts: 13
Joined: Thu Jul 15, 2010 11:50 am
Location: Newport Pagnell


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests