一.什么是SQLDMO
SQLDMO,也就是SQL Distributed Management Objects,即SQL分布式管理对象。SQLDMO封装了SQL SERVER 2000数据库中的所有对象。我以前也没看到过写SQLDMO的文章(学编程过程中学过的资料),在一个介绍SQLDMO的网站http://www.csharphelp.com/archives2/archive342.html上看到他说这个并没有被广泛地知道和使用。但SQLDMO提供了很强大的功能,能够使我们通过编程来对SQL SERVER几乎做任何SQL SERVER可以做的事。换句话说,使用SQLDMO的应用程序可以执行SQL SERVER企业管理器执行的所有功能。
二.如何使用SQLDMO
SQLDMO对象来自SQLDMO.dll,而后者是和SQL SERVER 2000一起发布的(SQL SERVER 2005也是一样),所以SQLDMO对象本身就是一个COM对象。当你想在VS中使用它时,首先必须引用它:
引用好后,你就可以很方便地使用SQLDMO了。我们一般可能比较多的会使用下面这几个对象:
a.SQLDMO.Application
b.SQLDMO.SQLServer
c.SQLDMO.Database
d.SQLDMO.NameList
接着介绍几个例子。
首先是得到网络中的SQL服务器的列表:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
接着是得到指定SQL服务器中的所有数据库:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
得到所有的存储过程:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
真的是太方便了。通过这几个入门级的基本例子,我们可以看到SQLDMO的威力了。这么好的东西,你还不赶快试试,你能写出让别人感觉更专业的程序!
参考资料:
http://www.csharphelp.com/archives2/archive342.html
http://www.microsoft.com/china/community/Column/29.mspx