How can we help you today? How can we help you today?

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.
Jeff Guge
0

Comments

2 comments

Sort by
  • dyard
    i am getting this same error did you get a solution?
    dyard
    0
  • DanC
    Hi @dyard @...

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

Add comment

Please sign in to leave a comment.