Sqldmo is provided by sqldmo. dll of Microsoft SQL Server. Because sqldmo. dll is a COM object, you must add references to it in the. NET project before using sqldmo. dll. Note that the COM reference is added. In the list, find "Microsoft sqldmo Object Library (possible path: system drive letter: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ sqldmo. DLL), and click OK to add the reference.
The following are Microsoft SQL Server classes written in C:
Using system;
Using system. Collections. Generic;
Using system. text;
Namespace allsqlserver
{
Class Program
{
Static void main (string [] ARGs)
{
Sqldmo. namelist names;
Sqldmo. applicationclass AC = new sqldmo. applicationclass ();
Names = ac. listavailablesqlservers ();
String [] serverlist = new string [names. Count];
For (INT I = 0; I <serverlist. length; I ++)
{
Serverlist [I] = names. item (I );
}
Foreach (string STR in serverlist)
{
Console. writeline (STR );
}
Console. Readline ();
}
}
}