What are the challenges you face when working across database platforms? Take the survey
Options

DDL statements ALTER, DROP and CREATE inside user transactions are not supported with memory optimiz

Getting this error with Version 3.3.0 trying to deploy a new memory optimized table type.

##[warning]The error 'DDL statements ALTER, DROP and CREATE inside user transactions are not supported with memory optimized tables.' occurred when executing the following SQL:
##[warning]CREATE TYPE [dbo].[IDListTableType_MO] AS TABLE
##[warning](
##[warning][ID] [int] NOT NULL,
##[warning]INDEX [IX_temp_Id] NONCLUSTERED ([ID])
##[warning])
##[warning]WITH
##[warning](
##[warning]MEMORY_OPTIMIZED = ON

This worked fine with sql compare 14 to deploy to test but is not working with the dev ops build process... Help.
Tagged:

Comments

Sign In or Register to comment.