Potential Error in SQL Doc

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Potential Error in SQL Doc

Postby feemurk » Wed Jan 23, 2008 1:04 am

Hi Folks,

I think I found an error in the functionality of SQL Doc.

In my environment, instead of using schemas to group code insofar as access and security are concerned, the generic concept of part-naming objects is used to organize code within any given schema.

Example:
[dbo].[Module1.Table1]

SQL Doc does not handle this appropriately. The stored procedures being declared in a similar fashion result in the following problem.

Stored Procedure [dbo].[Module1.sp1] used the tables
[dbo].[Module1.Table1],
[dbo].[Module1.Table2],
[dbo].[Module1.Table3]

The documentation returns the following in the "USES" section of the stored procedure documentation:

[dbo] [Module1].[Table1], [Module1].[Table2], [Module1].[Table3]

That is not correct. TSQL Interprets the [Module1].[Table1] as Schema named [Module1] in which there is a table named [Table1].

It should return:

[dbo] [Module1.Table1], [Module1.Table2], [Module1.Table3]

Regards,

Fahim.
feemurk
 
Posts: 1
Joined: Wed Feb 07, 2007 6:48 pm

Postby Robert » Wed Jan 23, 2008 11:18 am

Hi,

Thanks for reporting that - I've just recreated it here, and I see the same result as you.

The individual object pages correctly show [dbo].[Module1.Table1], so it just seems to be the uses / used by statements that are wrong.

I've logged it in our bug tracking system (issue SDOC-780), so hopefully it should get fixed for the next release of SQL Doc.

Many thanks,
Robert
Robert Chipperfield
Developer, Red Gate Software Ltd
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 0 guests