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

JeffG

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.

dyard

i am getting this same error did you get a solution?

DanC

Hi @dyard @JeffG

Are you using a SQL Source Control or SQL Change Automation project first of all?