title: Set Locale of a SQL Server 2005
body: <p>By default the SQL Server comes with the Langauge set to "English (United States)", setting the date format to mm/dd/yy instead of the date format I want it in, which is Australian and has a date format such as dd/mm/yy.</p>
  
  <p>Is there an option in the Server Management Studio / Configuration tools where I can set the locale of the SQL Server, which will prevent the DateTime fields from being formatted in US date format?</p>
  
  <p>If not, how can I convert it when I am using a SQL query such as (forgive me if there is incorrect syntax, I made it up on the spot):</p>
  
  <pre><code>Dim dc As New SqlCommand("INSERT INTO hello VALUES (@Date)", cn)
  dc.Parameters.Add(New SqlParameter("Date", System.DateTime.Now))
  </code></pre>
  
  <p>Many thanks in advance. :)</p>