When I insert a row in TableA in sql server I use this for the geometry column: geometry::STPolyFromText('POLYGON((x1,y1,x2,y2,x3,y3,x4,y4,x1,y1))', 3007)
You can find the definition for EPSG:3007 here. EPSg:3007 have an false easting of 150000 and when I look at the coordinates after the insert they are moved 150000m east.
When I create a new table, TableB, by generating a create-script from TableA and just changing the name, the same insert in TableB doesn't move the coordinates eastwards.
When changing from 3007 -> 0 in the insert-script I get the correct coordinates in both TableA and TableB.
Is there anyone that can explain this behavier? Is there a setting on the geometry-column that change the coordinates?