New Tables and Relationships in VB don't appear in SQL Management Studio Express?
I'm developing a VB/SQL application and I need to modify the table structures and their relationships. I thought I could work in either Visual Studio or SSMSEE (SQL Server (Management Studio Express Edition) and it would be "seamless". This is not the case.
If I add a table in VS 2005 it will appear in SSMSEE (in a database diagram) as will its primary keys. However, if I add a relationship (parent/child), then that relationship won't appear in SSMSEE. If I add the table and relationship in SSMSEE, these changes WILL appear in VS 2005.
I am using SQL Server Express v9.0.2047 (sp1) and the latest version of SSMSEE.
I am using Visual Studio Standard Edition (is there an SP1? I didn't find any on the web)
Is this a bug?
What is the best way to modify the table structures...in Visual Studio? .... or SQL Management Studio?
Richard
