Technical Article

Enumerate SQL Servers using SQLDMO and T-SQL

Microsoft reported BUG :ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E .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. However, there is some solution to get SQL servers using Client […]

2002-06-19

455 reads

Blogs

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Daily Coping 22 Mar 2023

By

Today’s coping tip is to appreciate your hands and all the things they do...

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Read the latest Blogs

Forums

Swapping coordinate pairs round

By Charlottecb

So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...

DOP_FEEDBACK in SQL MI

By cooldude001

I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...

index analysis help

By vsamantha35

Hi All, We see some tables in Prod are having 20-30 indexes and we...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers