Ramblings on all things SQL Server, Integration Services, Service Broker Reporting Services, TSQL, Replicaton, Full Text Search Spatial data and more by Simon Sabin : UK Microsoft MVP - SQL Server If you have any questions please feel free to contact me
For a list of spatial references and their definitions including units of measure have a look at the system view
select * from sys.spatial_reference_systems
Now, try to create your own spatial reference definition using INSERT INTO :-(