Table set options not committed to source control
sgtwickoolOld
Posts: 4 Bronze 1
Hello!
I am having some issues with set options (e.g. SET ANSI_PADDING ON; etc etc ) not being committed into source control with create table scripts. Are these settings excluded by design or is there a setting somewhere that will allow these to be included with the create table script? This is causing issues when loading objects to a blank database as the new table will not necessarily be created with the same set options as the original table.
Cheers,
Greg
I am having some issues with set options (e.g. SET ANSI_PADDING ON; etc etc ) not being committed into source control with create table scripts. Are these settings excluded by design or is there a setting somewhere that will allow these to be included with the create table script? This is causing issues when loading objects to a blank database as the new table will not necessarily be created with the same set options as the original table.
Cheers,
Greg
Comments
As detailed in the support ticket open this appears to be caused by a bug which we are currently investigating.
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools