How do I copy tables in SQL Server 2005 to a new instance while maintaining the foreign keys and identity columns in the source instance?<BR><BR>The import/export function in Management Studio creates ...

I have two tables that I want to relate on a many-to-many basis. I know that I have to create a transition table between the two tables, but is there any special way I need to create the table so that ...