Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Zach Nichter Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The RE: Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

  • November 10, 2006 at 5:48 am

    #671052

    On our system we get out of memory errors when we use code that utilizes sp_OACreate and other associated extended stored procedures.  The MemToLeave seems to get fractured and the fix is stopping and starting SQL Server to reallocate the virtual memory.