title: Conversion failed when converting from a character string to uniqueidentifier
body: <p>Please note that presently I am attempting to execute the following INSERT command via C# ADO.NET, but am receiving the above error:</p>
  
  <pre><code>INSERT INTO tblStampAnnotation ([StampAnnotationID],[Title],[Subject],[Content],[Author],[Date],[LinkedDocumentsID],[PageNumber],[Colour]) VALUES('{6b15a625-b967-4d3b-9ee3-34f64633f469}','test title','test subject','test content','test author',GETDATE(),'{475f30a1-142f-4fd5-b783-598d838559de}',1,Null)
  </code></pre>
  
  <p>Found a small program to check if GUID is correct here:  <a href="http://www.devx.com/vb2themax/Tip/18293" rel="nofollow">http://www.devx.com/vb2themax/Tip/18293</a></p>
  
  <p>When I run the program, it indicates that both the {6b15a625-b967-4d3b-9ee3-34f64633f469} and {475f30a1-142f-4fd5-b783-598d838559de} are GUIDs.  Does anyone have any suggestions to determine why I am receiving this error?  TIA.</p>
  
  <p>UPDATE:</p>
  
  <p>Thank you for the suggestion, bobs; however, when I use the following command I still get the same error:</p>
  
  <pre><code>INSERT INTO tblStampAnnotation ([StampAnnotationID],[Title],[Subject],[Content],[Author],[Date],[LinkedDocumentsID],[PageNumber],[Colour]) VALUES('6b15a625-b967-4d3b-9ee3-34f64633f469','test title','test subject','test content','test author',GETDATE(),'475f30a1-142f-4fd5-b783-598d838559de',1,Null)
  </code></pre>
  
  <p>UPDATE 2:
  Please note that I am using SQL Server 2008.</p>
  
  <p>UPDATE 3:
  This is getting strange.  I still receive the same error when I use NEWID():</p>
  
  <pre><code>INSERT INTO tblStampAnnotation ([StampAnnotationID],[Title],[Subject],[Content],[Author],[Date],[LinkedDocumentsID],[PageNumber],[Colour]) VALUES(NEWID(),'test title','test subject','test content','test author',GETDATE(),NEWID(),1,Null)
  </code></pre>