1
Vote

Error in PortalSettings

description

SQL Query should read:

PRINT N'Set Time zone standard for Mountain Time'

UPDATE {databaseOwner}[{objectQualifier}PortalsSettings]
SET [SettingValue] = 'Mountain Standard Time'
WHERE [SettingName] = 'TimeZone'
    AND [SettingValue] <> 'Pacific Standard Time'    --'Mountain Standard Time'
GO

Instead of:

PRINT N'Set Time zone standard for West Europe'

UPDATE {databaseOwner}[{objectQualifier}PortalsSettings]
SET [TimezoneOffset] = 'W. Europe Standard Time'
WHERE [SettingName] = 'TimeZone'
    AND [SettingValue] <> 'W. Europe Standard Time'
GO

TimeZoneOffset is not a column in the PortalSettings table....

comments