title: Is there a way to specify the Date Format used with SQLServer Management Object Scripting
body: <p>When I'm generating my database scripts for my project I'd like to manage the date format that is used in the comments in the SQLScript.</p>
  
  <p>I have my regional settings set to Australian format, but they seem to be disregarded.</p>
  
  <pre><code>Imports Microsoft.SqlServer.Management
  ...
          Dim scr As Smo.Scripter
          Dim opt As Smo.ScriptingOptions
  
  ...
          opt = New Smo.ScriptingOptions
          opt.???? =  //Is there something that I can set to control the date?
          opt.Encoding = Encoding.ASCII
          opt.DriAll = True
          opt.ClusteredIndexes = True
          opt.Default = True
          opt.Indexes = True
          opt.IncludeHeaders = True
          opt.AppendToFile = True
  </code></pre>
  
  <p>Results in a script with comments that look like this... Note the date is in US Format. </p>
  
  <pre><code>    /****** Object:  Table [dbo].[AAAExampleData]    Script Date: 06/17/2009 10:08:38 ******/
      SET ANSI_NULLS ON
  </code></pre>
  
  <p>I know that the Comments are only for readability, but I'd like complete control over my output.</p>
  
  <p>If it's not possible, please just say that.</p>