Red Gate forums :: View topic - Potential Error in SQL Doc
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

Potential Error in SQL Doc

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
feemurk



Joined: 07 Feb 2007
Posts: 1

PostPosted: Wed Jan 23, 2008 1:04 am    Post subject: Potential Error in SQL Doc Reply with quote

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.
Back to top
View user's profile Send private message
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Wed Jan 23, 2008 11:18 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group