title: DATENAME(MONTH,GETADATE()) is returning numeric value of the month as '09'
body: <p>When I run the following query [SELECT DATENAME(MONTH,GETDATE())], ideally speaking it should return value as 'September' but its returning value as '09'. I am running this query on MS SQL Server 2005. Is there anything I need to configure with MS SQL Server 2005?</p>
  
  <p>Please find the details of the SQL Server 2005 </p>
  
  <pre>
  Component Name                                Version
  --------------------------------------------------------------------
  Microsoft SQL Server Management Studio        9.00.1399.00
  Microsoft Analysis Services Client Tools      2005.090.1399.00
  Microsoft Data Access Components (MDAC)       2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
  Microsoft MSXML                               2.6 3.0 4.0 5.0 6.0 
  Microsoft Internet Explorer                   6.0.3790.3959
  Microsoft .NET Framework                      2.0.50727.42
  Operating System                              5.2.3790
  </pre>