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
Back to the top
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>
Back to the top
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Back to the top
