month name in SQL Server 2000

DATENAME ( datepart , date )

DatePart ::

1. mm month
2. yy,yyyy year
3. dd, d day

etc.......

Example :

select datename(mm,getdate())

or

select datename(month,getdate())