----------------------------------------------------------------------------------------------------------------------
Verify the current value for the "Max" file size for data upload. By default the value is set to "8"
Use MSCRM_CONFIG
SELECT ColumnName, IntColumn FROM ServerSettingsProperties
where ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go
To change the value you would need to apply the below statement. It will change the default value from 8 to 10. As a result the max file size for data import will now be 10 MB.
Use MSCRM_CONFIG
UPDATE [MSCRM_CONFIG].[dbo].[ServerSettingsProperties]
SET [IntColumn] = '10'
WHERE ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go
------------------------------------------------------------------------------------------------------------------------
Verify the current value for the "Max" file size for data upload. By default the value is set to "8"
Use MSCRM_CONFIG
SELECT ColumnName, IntColumn FROM ServerSettingsProperties
where ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go
To change the value you would need to apply the below statement. It will change the default value from 8 to 10. As a result the max file size for data import will now be 10 MB.
Use MSCRM_CONFIG
UPDATE [MSCRM_CONFIG].[dbo].[ServerSettingsProperties]
SET [IntColumn] = '10'
WHERE ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go
------------------------------------------------------------------------------------------------------------------------