My (mostly technical) blog

Compatibility: Microsoft SQL Server Azure Spatial

Posted by: sabbour on: June 28, 2010

As I’m just trying out Microsoft SQL Server Azure Spatial, the following things need to be removed from any generated SQL script in order to make it run on SQL Server Azure as they are not supported:

ON [PRIMARY]
PAD_INDEX
ALLOW_ROW_LOCKS
ALLOW_PAGE_LOCKS
SORT_IN_TEMPDB
newsequentialid()

I will keep this post updated as I discover new booby traps!
For a full list, check: http://msdn.microsoft.com/en-us/library/ee336253.aspx 
Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Ahmed Sabbour's Facebook profile

 

June 2010
S M T W T F S
« Apr   Apr »
 12345
6789101112
13141516171819
20212223242526
27282930  

Tweets

RSS StackOverflow

  • Answer by sabbour for j2me: how to open application page via ovi store app February 22, 2012
    If the Nokia Store is installed, then opening the above URL in the browser will cause the Store client to open on the specified app.
  • Answer by sabbour for Horizontal listView inside Vertical Listview in qml February 22, 2012
    I tried this solution on the simulator and it worked. import QtQuick 1.1 import com.nokia.symbian 1.1 Page { id: mainPage anchors.fill: parent ListModel { id: colorsModel ListElement { colorCode: "red" } ListElement { colorCode: "green" } ListElement { colorCode: "blue" } ListElement { colorCode: "orange" } ListElement […]
  • Answer by sabbour for Push Notification for Nokia nid using c# February 20, 2012
    Please check the following project: https://projects.forum.nokia.com/dotnet_notifications_api It is a .NET wrapper for the Nokia Notifications API.
  • Answer by sabbour for Unable to compile Qt Symbian application that uses gSOAP September 13, 2010
    To finally make it work, I had to port gSOAP to use stdapis instead of libc. I removed one of the lines and used instead. You can find the ported stdsoap2.h file at http://pastebin.com/xnrDbfFa. I also discovered that Symbian does not load STL by default, so all my methods that were returning std::vector and std::string are now not compiling. Instead of opti […]
  • Unable to compile Qt Symbian application that uses gSOAP September 8, 2010
    I'm using gSOAP along with Qt for Symbian. Under the emulator, the application compiles fine, but when I change the target of the compiler to compile for the device, I get the following error. WARNING: Can't find following headers in System Include Path This gets included from the stdsoap2.h file as follows: #ifndef WITH_NOIO # ifndef WIN32 # ifnde […]

Recently bookmarked

Follow

Get every new post delivered to your Inbox.