 | |
Re: What memory-space is used by sp_oacreate ?
microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: What memory-space is used by sp_oacreate ? -
07-15-2003
, 09:56 AM
|
Hi, When I run "EXEC @iHr = sp_OACreate 'CDO.Message', @iMessageObjId OUT" what memory-space is used ? What are the limits ? This works fine, until after a while I get : "Error setting Message configuraton field "smtpserver". [SQLSTATE 01000] (Message 0) CDO.Configuration.1 [SQLSTATE 01000] (Message 0) Not enough storage is available to process this command. [SQLSTATE 01000] (Message 0)." At the end of this sp " EXEC @iHr = sp_OADestroy @iMessageObjId" is always executed. Any hints ? jobi |
#2
| |||
| |||
|
|
That really depends on the component, but probably it will come out of the default heap of SQL Server, since CDO is an in-process COM component. GertD (AT) SQLDev (DOT) Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2003 All rights reserved. "jobi" <jobi (AT) reply2 (DOT) group> wrote in message news:bf0k6k$hvr$1 (AT) reader08 (DOT) wxs.nl... Hi, When I run "EXEC @iHr = sp_OACreate 'CDO.Message', @iMessageObjId OUT" what memory-space is used ? What are the limits ? This works fine, until after a while I get : "Error setting Message configuraton field "smtpserver". [SQLSTATE 01000] (Message 0) CDO.Configuration.1 [SQLSTATE 01000] (Message 0) Not enough storage is available to process this command. [SQLSTATE 01000] (Message 0)." At the end of this sp " EXEC @iHr = sp_OADestroy @iMessageObjId" is always executed. Any hints ? jobi |
#3
| |||
| |||
|
|
Is there any way I can get it out of the SQLServer - memory ? Or How can I check how many occurences of this component are active in memory ? Apparently something is leaking and I get wet feed  Mails are nolonger going out and I'll need a least a stop/start of the SQLServer-service. Maybe this is the same issue that keeps coming up with the regular SQLMail on this cluster. (that was the reason to use smtp-mail) jobi "Gert E.R. Drapers" <GertD (AT) SQLDev (DOT) Net> wrote in message news:uBmbEFuSDHA.1572 (AT) TK2MSFTNGP12 (DOT) phx.gbl... That really depends on the component, but probably it will come out of the default heap of SQL Server, since CDO is an in-process COM component. GertD (AT) SQLDev (DOT) Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2003 All rights reserved. "jobi" <jobi (AT) reply2 (DOT) group> wrote in message news:bf0k6k$hvr$1 (AT) reader08 (DOT) wxs.nl... Hi, When I run "EXEC @iHr = sp_OACreate 'CDO.Message', @iMessageObjId OUT" what memory-space is used ? What are the limits ? This works fine, until after a while I get : "Error setting Message configuraton field "smtpserver". [SQLSTATE 01000] (Message 0) CDO.Configuration.1 [SQLSTATE 01000] (Message 0) Not enough storage is available to process this command. [SQLSTATE 01000] (Message 0)." At the end of this sp " EXEC @iHr = sp_OADestroy @iMessageObjId" is always executed. Any hints ? jobi |
#4
| |||
| |||
|
|
Is there any way I can get it out of the SQLServer - memory ? Or How can I check how many occurences of this component are active in memory ? Apparently something is leaking and I get wet feed Mails are nolonger going out and I'll need a least a stop/start of the SQLServer-service. Maybe this is the same issue that keeps coming up with the regular SQLMail on this cluster. (that was the reason to use smtp-mail) jobi "Gert E.R. Drapers" <GertD (AT) SQLDev (DOT) Net> wrote in message news:uBmbEFuSDHA.1572 (AT) TK2MSFTNGP12 (DOT) phx.gbl... That really depends on the component, but probably it will come out of the default heap of SQL Server, since CDO is an in-process COM component. GertD (AT) SQLDev (DOT) Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. Copyright © SQLDev.Net 1991-2003 All rights reserved. "jobi" <jobi (AT) reply2 (DOT) group> wrote in message news:bf0k6k$hvr$1 (AT) reader08 (DOT) wxs.nl... Hi, When I run "EXEC @iHr = sp_OACreate 'CDO.Message', @iMessageObjId OUT" what memory-space is used ? What are the limits ? This works fine, until after a while I get : "Error setting Message configuraton field "smtpserver". [SQLSTATE 01000] (Message 0) CDO.Configuration.1 [SQLSTATE 01000] (Message 0) Not enough storage is available to process this command. [SQLSTATE 01000] (Message 0)." At the end of this sp " EXEC @iHr = sp_OADestroy @iMessageObjId" is always executed. Any hints ? jobi |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.