title: Getting around cyclical foreign key errors when trying to generate insert data scripts in SQL 2008
body: <p>I am trying to generate some insert scripts using the SQL Server 2008 Script Wizard. Upon generating the scripts, I get the following error: </p>
  
  <p><em>"The selected database contains foreign keys that create a cycle. Publishing data only is not supported for databases with cyclical foreign key relationships."</em></p>
  
  <p>I've attempted to disable and remove all constraints in the database. The error is still occurring. Is there any way to get around this? Possibly make SQL ignore the constraints while generating the scripts.</p>