I am trying to get a list of server databases from within my visual studio windows forms project. I am using the following to the a list of available servers and everything works ok:
Dim dataTable = SmoApplication.EnumAvailableSqlServers(False)
datServers.ValueMember = "Name"
datServers.DataSource = dataTable
I am using this code to list all of the databases for the past servers. It works fine and returns all of the databases for some servers but others I get a connection error. All of the severs are SQL server 2008 R2
Dim server As New Microsoft.SqlServer.Management.Smo.Server(xServer)
For Each db As Microsoft.SqlServer.Management.Smo.Database In server.Databases
I can figure out why it works for one sever but not the other.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…