title: sp_generate_inserts for SQL Server 2008
body: <p>I've been using Narayana Vyas Kondreddi's excellent stored procedure <code>sp_generate_inserts</code> <a href="http://vyaskn.tripod.com/code/generate_inserts.txt" rel="noreferrer">http://vyaskn.tripod.com/code/generate_inserts.txt</a> in a SQL Server 2005 database. </p>
  
  <p>But after moving to SQL Server 2008 I get weird results where a long whitespace is inserted after UNIQUEIDENTIFIER values:</p>
  
  <pre><code>INSERT INTO [BannerGroups]([Id], [DescriptionText], [Width], [Height]) 
  VALUES('BFCD0173-9432-47D1-84DF-8AB3FB40BF76                                                                                                                                                                                                                           ', 'Example', 145, NULL)
  </code></pre>
  
  <p>Anyone know how to fix this?</p>