Attempting to follow directions from @SteveJones & MS documentation for setting up key for Azure Sql Server cross database queries.
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<master_key_password>';
CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH IDENTITY = '<username>',
SECRET = '<password>';
We're receiving an error with the IDENTITY parameter. The examples look very straightforward but aren't working for us. Error: Incorrect syntax near 'IDENTITY'. Expecting CREATEDBOPT_BACKUPSTORAGEREDUNDANCY, CREATEDBOPT_CATALOGCOLLATION, CREATEDBOPT_FILESTREAM, CREATEDBOPT_LOGAPPLY, CREATEDBOPT_OTHER, or CREATEDBOPT_PERSISTENT_LOG_BUFFER.
We can't find any reference to this error or the parameter.
What are we missing?