How to set relationship level when creating diagram?

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/

How to set isolation level permanently in sql server and how to check

Hi,
How to set isolation level permanently in sql server
and how to check my currenct isolation level?
Thank you
regards,
florence
> How to set isolation level permanently in sql server
No can do. Set it in your code.

> and how to check my currenct isolation level?
DBCC USEROPTIONS
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"florencelee" <anonymous@.discussions.microsoft.com> wrote in message
news:157f01c4a6de$7b0174a0$a401280a@.phx.gbl...
> Hi,
> How to set isolation level permanently in sql server
> and how to check my currenct isolation level?
> Thank you
> regards,
> florence
>

How to set isolation level permanently in sql server and how to check

Hi,
How to set isolation level permanently in sql server
and how to check my currenct isolation level?
Thank you
regards,
florence> How to set isolation level permanently in sql server
No can do. Set it in your code.
> and how to check my currenct isolation level?
DBCC USEROPTIONS
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"florencelee" <anonymous@.discussions.microsoft.com> wrote in message
news:157f01c4a6de$7b0174a0$a401280a@.phx.gbl...
> Hi,
> How to set isolation level permanently in sql server
> and how to check my currenct isolation level?
> Thank you
> regards,
> florence
>