At this moment I'm following this tutorial: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-getting-started/
But when I use this code:
CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH (TYPE = SHARD_MAP_MANAGER, LOCATION = '<used_my_server_name_here>.database.windows.net', DATABASE_NAME = 'ElasticScaleStarterKit_ShardMapManagerDb', CREDENTIAL = ElasticDBQueryCred, SHARD_MAP_NAME = 'CustomerIDShardMap' ) ;
I get the following error message:
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'EXTERNAL'.
At the moment I'm using the latest version of the SQL 2014 management studio:
Microsoft SQL Server Management Studio 12.0.4416.0Microsoft Analysis Services Client Tools 12.0.4416.0
Microsoft Data Access Components (MDAC) 6.3.9600.16384
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 9.11.9600.16384
Microsoft .NET Framework 4.0.30319.34003
Operating System 6.3.9600
Does anyone know how to solve this?