At my company, we just made the move from using Microsoft Access in our website to using SQL Server. I have no prior experience with SQL Server. We are not hosting the server locally. It is being hosted on a virtual server at Intermedia.net. We connected to the SQL server using a Microsoft Access Project. We imported all the tables from the Micrsoft Access database into the new SQL Server database. Now, in trying to reestablish the relationships between the tables. I started a New Diagram, and proceeded to layout all the relationships. However, errors were generated revolving around tables with multiple primary keys, and certain columns which said that the relationship violated existing contraints. I know this is a general problem, but does anyone have any idea what is going on? Can anyone offer me general advice on Diagrams in SQL Server?
Thanks for your help,
Justin
Thanks for your help,
Justin