RE: Run-time error while processing Inventory Transfers
I have previously filed a case with Microsoft on this issue and they had recommended changing the maximum memory in SQL as follows:
Follow these steps to set the Memory to a more appropriate value:
1.On the Start menu, right-click My Computer, and then click Properties. Note the amount of memory that is installed on the computer.
2.Set the value for Maximum Server Memory to a value that is 25% of the total amount of memory that you idetified in step 1. For example, if you have 2GBs (2,048MBs) of memory on your computer take 2GBs (2,048MBs) times 25% to equal 512MBs. (2048 * .25 = 512).
Note Follow these steps to set the value for the Maximum Server Memory: a.Open SQL Server 2008 Management Studio (Start - All Programs - Microsoft SQL Server 2008 - SQL Server Management Studio).
b.Connect to the instance running RMS.
c.In Object Explorer, right-click the SQL Server instance, and then click Properties.
d.Click the Memory node.
e.In the Server Memory Options area, type the value that you want for Maximum server memory (in the example from step 2, you would enter 512).
f.Click OK.
Share
Report
105
All responses (
Answers (
