This enables you to not let any other Spatial Reference ID inserted into a spatial column. This is inherently allowed but when you want to do operations on the column they must all be of the same spatial reference.
alter table customers
add constraint [enforce_SRID_GeogaphyColumn]
check (location.STSrid = 4326)
create TABLE customers
(
FirstName nvarchar(30),
LatName nvarchar(30)
)
alter table customers
add location geography
alter table customers
add constraint [enforce_SRID_GeogaphyColumn]
check (location.STSrid = 4326)
drop table customers