title: Export SQL Server 2005 query result to SQL INSERT statement?
body: <p>Is there an easy way in SQL Server 2005 to export query results to a SQL INSERT statement? I'm thinking something along the lines of how you can use Database Explorer to script an existing stored procedure to a new query window.</p>
  
  <p>We're looking to move some data from a dev DB to a production one; I know about linked servers but there's no way the DBA blackshirts will let us set that up.</p>
  
  <p>A definitive, "Nope, you're boned," will suffice if it has to.</p>
  
  <p>Edit: The table I want to insert into is not on the same database server. Without setting up a linked server, I can't do a select into.</p>