Geen kolommen bij GLAccountsBulk in SQL Server Management Studio 18

Vragen
,
1

De kolommenlijst is leeg:

image
image1166×894 426 KB

2

De kolommenlijst verschijnt wel op v18.12.1, maar aanklikken tabel geeft een (verborgen) foutmelding:

itgensql056
Syntax error between the two ‘***’ on line 2, column 97:

CREATE TABLE #tmp_exte…ter_predicate nvarchar(max) null, migration_state tinyint n…

Error: no viable alternative at input ‘CREATE TABLE #tmp_extended_remote_data_archive_tables\r\n (object_id int not null, remote_table_name nvarchar(128) null, filter_predicate nvarchar(max’.

met SQL-statement:

CREATE TABLE #tmp_extended_remote_data_archive_tables
        (object_id int not null, remote_table_name nvarchar(128) null, filter_predicate nvarchar(max) null, migration_state tinyint null)

        IF EXISTS(SELECT 1 FROM master.sys.syscolumns WHERE Name = N'remote_data_archive_migration_state' AND ID = Object_ID(N'sys.tables'))
        EXECUTE(N'INSERT INTO #tmp_extended_remote_data_archive_tables SELECT rdat.object_id, rdat.remote_table_name,
        SUBSTRING(rdat.filter_predicate, 2, LEN(rdat.filter_predicate) - 2) as filter_predicate,
        CASE
        WHEN tbl.remote_data_archive_migration_state_desc = N''PAUSED'' THEN 1
        WHEN tbl.remote_data_archive_migration_state_desc = N''OUTBOUND'' THEN 3
        WHEN tbl.remote_data_archive_migration_state_desc = N''INBOUND'' THEN 4
        WHEN tbl.remote_data_archive_migration_state_desc = N''DISABLED'' THEN 0
        ELSE 0
        END AS migration_state
        FROM sys.tables tbl LEFT JOIN sys.remote_data_archive_tables rdat ON rdat.object_id = tbl.object_id
        WHERE rdat.object_id IS NOT NULL')
        ELSE
        EXECUTE(N'INSERT INTO #tmp_extended_remote_data_archive_tables SELECT rdat.object_id, rdat.remote_table_name,
        SUBSTRING(rdat.filter_predicate, 2, LEN(rdat.filter_predicate) - 2) as filter_predicate,
        CASE
        WHEN rdat.is_migration_paused = 1 AND rdat.migration_direction_desc = N''OUTBOUND'' THEN 1
        WHEN rdat.is_migration_paused = 1 AND rdat.migration_direction_desc = N''INBOUND'' THEN 2
        WHEN rdat.is_migration_paused = 0 AND rdat.migration_direction_desc = N''OUTBOUND'' THEN 3
        WHEN rdat.is_migration_paused = 0 AND rdat.migration_direction_desc = N''INBOUND'' THEN 4
        ELSE 0
        END AS migration_state
        FROM sys.tables tbl LEFT JOIN sys.remote_data_archive_tables rdat ON rdat.object_id = tbl.object_id
        WHERE rdat.object_id IS NOT NULL')
      


SELECT
CAST(tbl.is_remote_data_archive_enabled AS bit) AS [RemoteDataArchiveEnabled],
CAST(
        ISNULL(rdat.migration_state, 0)
       AS tinyint) AS [RemoteDataArchiveDataMigrationState]
FROM
sys.tables AS tbl
LEFT OUTER JOIN #tmp_extended_remote_data_archive_tables AS rdat ON rdat.object_id = tbl.object_id
WHERE
(tbl.name=@_msparam_0 and SCHEMA_NAME(tbl.schema_id)=@_msparam_1)

        DROP TABLE #tmp_extended_remote_data_archive_tables