For spacial you need SQL 2008 or above (2008, 2008 R2 or 2012).
Can't tell you which version or edition, not enough information. Review the documentation on MSDN, look at the features in each edition and version and see what you need and what you can afford.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability