You can also use this tool for converting shapefiles to SQL Server datatypes - Shape2SQL (http://www.sharpgis.net/page/Shape2SQL.aspx). I am currently using this tool to convert my shapefile to type geometry (planar). You can also convert it to geography data type but you might need to know your SRID of the shapefile.
commented on May 29 2010 1:32PM