locked
Sql Server 2008 Geography RRS feed

  • Question

  • I instal SQL Server 2008 R2, but when I try to create a table with some field type geometry o geography, I have next response from SQl Sever:

    CREATE

     

    TABLE gto

    (

    ID

    INT IDENTITY(1,1) NOT NULL,

    G

    GEOMETRY

    );

    Cannot find data type GEOMETRY.

    Do you Know if I need to change some option?

     

    Regards

    • Moved by Bob Beauchemin Tuesday, December 21, 2010 10:48 PM Probably get a better response in this forum (From:.NET Framework inside SQL Server)
    Tuesday, December 21, 2010 8:14 PM

Answers

  • Hello,

    Please check the version of the SQL Server you are connected to and the database compatibility level; version should be 2008 / 2008 R2 and comp level of the used database should be 100.

    -- Server-Version

    SELECT @@Version;

     

    -- Database comp level

    SELECT name

          ,compatibility_level

    FROM sys.databases

     


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, December 22, 2010 6:03 AM