I suppose its not entirely helpful to say that I recognize this error and that I know I've dealt with it in the past, but that I can't seem to...

You might also try messing around in EM's GUI, graphically querying tables, and see what T-SQL is created.  That helped me quite a lot whan I was getting started.

Here's a pretty comprehensive bit on disabling/re-enabling foreign keys and triggers:

http://msdn.microsoft.com/msdnmag/issues/07/04/DataPoints/