BUG: ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E (254759)

The information in this article applies to:

Microsoft SQL Server 6.5
Microsoft SQL Server 7.0
Microsoft Active Server Pages

This article was previously published under Q254759

SYMPTOMS

When you execute the ListAvailableServers method of the SQLDMO.Application object from an ASP page, the following error message may occur:

Microsoft SQL-DMO (0x800A000E)
[SQL-DMO]Not enough storage is available to complete this operation.
/SQLDMO.asp, line 10

WORKAROUND

This error only occurs when the method is called in server-side scripts. Executing the code using client-side scripts does not cause this error message. For example:

<SCRIPT LANGUAGE="VBScript" FOR=window EVENT=onload>
Dim oDMO, oServers
Set oDMO = CreateObject("SQLDMO.Application")
Set oServers = oDMO.ListAvailableSQLServers()
Msgbox "Total Number of Servers = " & oServers.Count
</SCRIPT>

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Modification Type:	Major	Last Reviewed:	11/17/2003
Keywords:	kbBug kbpending KB254759