All geek questions in one place

Unable to find data geography

I am using SQL Server 2008 R2, and it seems like I cannot use the type of geography column that he had in mind. It does not appear in the data type column when creating a new column and when running this code:

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

I get

Column, parameter or variable # 2: Unable to find data geography.

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

+3
source share
2 answers

At the risk of exposing the obvious, I double-check to make sure that the database you are using is actually on an instance of SQL 2008.

+3
source

, Management Studio, intellisense. , , ?

-1

Source: https://habr.com/ru/post/1752640/

More articles:


All Articles