Check out the next version of SQL with native Spatial support:

http://blogs.msdn.com/isaac/archive/2007/05/16/sql-server-spatial-support-an-introduction.aspx