Lookup or Item list display columns are NULL

Created by: Gunnar Steinn Magnússon

Older versions of exMon (older than 1.5) could, in some cases, set the display columns as null. To make sure all display columns are updated execute this script:


declare @table_id int

declare table_cursor CURSOR FOR

select distinct TableId from dbo.[Table]

OPEN table_cursor

FETCH NEXT FROM table_cursor  

INTO @table_id

WHILE @@FETCH_STATUS = 0  

BEGIN  

    print 'Processing table nr ' + cast(@table_id as varchar(5))

EXEC [dbo].[UpdateLookupDisplayColumns]

@LookupTableIdIn = @table_id

EXEC [dbo].[UpdateItemListDisplayColumns]

@TableIdIn = @table_id

    FETCH NEXT FROM table_cursor  

    INTO @table_id  

END  

CLOSE table_cursor;  

DEALLOCATE table_cursor;

Gunnar is the author of this solution article.