IF EXISTS( 
SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'pal_CalendarEvent' AND COLUMN_NAME = 'recurrenceRule'
AND CHARACTER_MAXIMUM_LENGTH = 500)
BEGIN
    ALTER TABLE pal_CalendarEvent 
    ALTER COLUMN recurrenceRule VARCHAR(4000) NULL;
END