lets say I have 3 levels of relational table
Level 1 is the master table
Level 2 has 10 tables and all are children table of level 1
level 3 has 100 tables and all are children of tables in level 2
And I am trying to use MS SQL 2005 to create a diagram.
In SQL2000 I used to able to set the relationship level. For example, if I set the level = 0 it will only add the master table. If I set the level = 1 it will add the master table and those 10 tables links to the master table.... so on so forth.
But now in SQL2005 when I choose "Add related tables" I will have to let those 112 tables all squashed in a tiny 17" screen and it become very unmanagable.
Is there any way I can set the relationship level again in SQL2005?
It appears that we did not implement this behavior. Could you file this as an issue on Microsoft Connect? http://connect.microsoft.com/SQLServer/. We will triage it and let you know if/when we can put it into a future release of the product.
Thanks,
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
No comments:
Post a Comment