SQL Server 2008 R2 Geography column?

Question

Hi, I'm using SQL Server 2008 R2 and I can't seem to be able to use the geography column type it's meant to have. It doesn't show up in the data type column when I create a new column and when I run this code:

CREATE TABLE [Core].[Address2](
 [Geo_Id] [geography] NULL);

I get

Column, parameter, or variable #2: Cannot find data type geography.

Am I doing something wrong or do I need to enable the new data types somehow?

Thanks

Answer 1

I have found that when you add a geography column you need to restart the Management Studio in order for it to appear in intellisense. This might be the issue you are having perhaps?

Answer 2

At the risk of stating the obvious, I'd double check to make sure the database you're using is indeed on a SQL 2008 instance.