SQL Server 2008 supports the Open Geospatial Consortium (OGC) methods on geometry instances.
For more information on Open Geospatial Consortium (OGC) specifications, see the following Open Geospatial Consortium Specifications:
OGC Specifications, Simple Feature Access Part 1 - Common Architecture
OGC Specifications, Simple Feature Access Part 2 – SQL Options
Other Resources
Extended Methods on Geometry Instances
OGC Static Geometry Methods
Extended Static Geometry Methods
Help and Information
Getting SQL Server 2008 Assistance