Getting Spatial Data into SQL Server 2008
A nice article by Mike Ormond explain SQL Server 2008 native support for spatial datatypes.
Read it at Mike Ormond's Blog
[Update]
You can also refer to the spatial data section and more information about the SQL Server Support for this datatype