﻿** Highlights
     Tables that will be rebuilt
       [ssis].[AuditRow]
       [ssis].[AuditRowData]
       [ssis].[ConfigVariable]
       [ssis].[RowCount]
     Clustered indexes that will be dropped
       None
     Clustered indexes that will be created
       None
     Possible data issues
       The column [ssis].[AuditRow].[ServerExecutionID] is being dropped, data loss could occur.
       The column [ssis].[AuditRow].[TaskExecutionID] is being dropped, data loss could occur.
       The column [ssis].[AuditRow].[ExecutionID] on table [ssis].[AuditRow] must be added, but the column has no default value
         and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must
         either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults
         as a deployment option.
       The column [ssis].[AuditRow].[ExecutionInstanceGUID] on table [ssis].[AuditRow] must be added, but the column has no
         default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this
         issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of
         smart-defaults as a deployment option.
       The column [ssis].[AuditRowData].[AuditRowDataID] is being dropped, data loss could occur.
       The column [ssis].[ConfigVariable].[IsEncrypted] is being dropped, data loss could occur.
       The type for column VariableValue in table [ssis].[ConfigVariable] is currently  SQL_VARIANT NOT NULL but is being
         changed to  VARCHAR (200) NOT NULL. Data loss could occur.
       The column [ssis].[RowCount].[ServerExecutionID] is being dropped, data loss could occur.
       The column [ssis].[RowCount].[TaskExecutionID] is being dropped, data loss could occur.
       The column [ssis].[RowCount].[ExecutionID] on table [ssis].[RowCount] must be added, but the column has no default value
         and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must
         either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults
         as a deployment option.
       The column [ssis].[RowCount].[ExecutionInstanceGUID] on table [ssis].[RowCount] must be added, but the column has no
         default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this
         issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of
         smart-defaults as a deployment option.

** User actions
     Drop
       on [ssis].[AuditRow].[AuditRowDate] (Default Constraint)
       on [ssis].[ConfigVariable].[SystemName] (Default Constraint)
       on [ssis].[ConfigVariable].[ObjectName] (Default Constraint)
       on [ssis].[ConfigVariable].[IsEncrypted] (Default Constraint)
       on [ssis].[RowCount].[RowCountDate] (Default Constraint)
       [ssis].[LogAuditRow] (Procedure)
       [dbo].[AuditRowDataType] (User-Defined Table Type)
     Create
       [dbo].[AuditRowDataType] (User-Defined Table Type)
       [ssis].[Execution] (Table)
       [ssis].[Execution].[UIX_ssis_ServerExecution] (Index)
       [admin].[GetColumnListStatement] (Function)
       [admin].[GetForeignKeyStatement] (Function)
       [ssis].[LogAuditRow] (Procedure)
       [ssis].[LogExecution] (Procedure)
     Table rebuild
       [ssis].[AuditRow] (Table)
       [ssis].[AuditRowData] (Table)
       [ssis].[ConfigVariable] (Table)
       [ssis].[RowCount] (Table)
     Alter
       [ssis].[LogRowCount] (Procedure)
       [admin].[TableCopy] (Procedure)
       [admin].[TableDeploy] (Procedure)

** Supporting actions

The column [ssis].[AuditRow].[ServerExecutionID] is being dropped, data loss could occur.
The column [ssis].[AuditRow].[TaskExecutionID] is being dropped, data loss could occur.
The column [ssis].[AuditRow].[ExecutionID] on table [ssis].[AuditRow] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column [ssis].[AuditRow].[ExecutionInstanceGUID] on table [ssis].[AuditRow] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column AuditType on table [ssis].[AuditRow] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column [ssis].[AuditRowData].[AuditRowDataID] is being dropped, data loss could occur.
The column [ssis].[ConfigVariable].[IsEncrypted] is being dropped, data loss could occur.
The type for column VariableValue in table [ssis].[ConfigVariable] is currently  SQL_VARIANT NOT NULL but is being changed to  VARCHAR (200) NOT NULL. Data loss could occur.
The column [ssis].[RowCount].[ServerExecutionID] is being dropped, data loss could occur.
The column [ssis].[RowCount].[TaskExecutionID] is being dropped, data loss could occur.
The column [ssis].[RowCount].[ExecutionID] on table [ssis].[RowCount] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column [ssis].[RowCount].[ExecutionInstanceGUID] on table [ssis].[RowCount] must be added, but the column has no default value and does not allow NULL values. If the table contains data, the ALTER script will not work. To avoid this issue you must either: add a default value to the column, mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column ColumnName on table [ssis].[RowCount] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column CountType on table [ssis].[RowCount] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
The column RowCount on table [ssis].[RowCount] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
If this deployment is executed, changes to [ssis].[AuditRow] might introduce run-time errors in [rpt].[PackageExecution].
If this deployment is executed, changes to [ssis].[ConfigVariable] might introduce run-time errors in [ssis].[SetConfigVariable].
If this deployment is executed, changes to [ssis].[RowCount] might introduce run-time errors in [rpt].[PackageExecution].

