This one is for you advanced experts - SQL Server 7
I have a VB pgm that reads input from a communications port.
Got 'Error 28: Out of stack space'
This was a fatal error-Program crashes.
i think 28 is the severity level ?
This sounds like a problem caused by not having enough RAM.
The server has only 192MB. Considering we have data replication active to a second server, we know we need more memory.
I ran sp_configure; it shows many interesting settings but does NOT show the amount of stack space for this server.
(The default size is 4096 bytes)
Question 1: Would this error likely be caused by insufficient RAM ?
Question 2: What stored proc will show me the current setting for the stack size?
Thanks for your help. John
I have a VB pgm that reads input from a communications port.
Got 'Error 28: Out of stack space'
This was a fatal error-Program crashes.
i think 28 is the severity level ?
This sounds like a problem caused by not having enough RAM.
The server has only 192MB. Considering we have data replication active to a second server, we know we need more memory.
I ran sp_configure; it shows many interesting settings but does NOT show the amount of stack space for this server.
(The default size is 4096 bytes)
Question 1: Would this error likely be caused by insufficient RAM ?
Question 2: What stored proc will show me the current setting for the stack size?
Thanks for your help. John