Before Microsoft SQL Server 2005 comes up, users of this database wanting to handle spatial data had basically 3 options:
- ESRI ArcSDE – which means purchasing SDE licenses and probably some other ESRI product for data maintenance
- TerraLib – an OpenSource option including TerraView as default user interface. But, just like ArcSDE, TerraLib has its own data access model and won´t permit the use of spatial SQL
- or upgrade to SQL Server 2008 and finally enable spatial support natively from Microsoft
(click here to read this text)

Other SQL 2008 links:
http://www.bostongis.com/PrinterFriendly.aspx?content_name=sql2008_tut01
http://www.simple-talk.com/sql/learn-sql-server/gis-and-sql-server-2008-making-maps-with-your-data/
Comment by Eduardo Kanegae — November 7, 2009 @ 11:52 am
Also check:
1.http://lists.osgeo.org/pipermail/mapserver-users/2006-November/020892.html – how to connect SQL Server 2005 to MapServer using OGR ODBC driver
2.MS-SQL Server 2008 – this new version already has spatial data support and latest versions of MapServer has a plugin for connection to it – http://mapserver.org/development/rfc/ms-rfc-38.html
Comment by Eduardo Kanegae — November 7, 2009 @ 11:48 am