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