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 :-(
Pingback from Recent Links Tagged With "referneces" - JabberTags