EnumAvailableSqlServers does not list SQL 2000 server.

[hoangthu1974]

Hi all, I used VS2005 with EnumAvailableSqlServers to list all the SQL Server, but when I upgrade to VS Team 2008, EnumAvailableSqlServers does not list SQL 2000 Server in the list.

Imports Microsoft.SqlServer.Management.Smo.SmoApplication

Dim dtServer As DataTable = EnumAvailableSqlServers(False)

Please help me! Thanks a lot.

[Abhishek Sur]

Have you upgraded Sql Server as well ? SMO is changed in Sql Server 2008 :)

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>

[hoangthu1974]

Not yet, I use SQL Server 2005 Express and SQL Server 2000. Do I have to upgrade my SQL Server to 2008?

[Abhishek Sur]

No... Have you taken the proper reference to SMO dll.. Actually if you have, it should be working. The dlls will only change if you change the Version of Management objects. Check if the reference is kept intact after installing VS 2008. :cool:

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>

[hoangthu1974]

My VS Team 2008 DVD only have SQL 2005 Express. Thus, I have to buy SQL 2008 or only need SQL 2008 Express? Thanks.