October 2007 - Posts

• SQL 2008 SMO - Doing a Little Rearranging

  In browsing through the SQL Server 2008 SMO Object Library I noticed there are a couple of additional DLL's. For example, the SQL Server WMI Management objects, formerly in Microsoft.SqlServer.Smo.dll, are now in Microsoft.SqlServer.SqlWmiManagement.dll. Read More... Posted Friday, October 19, 2007 3:36 PM by AllenMWhite | 0 Comments Filed under: SMO, SQL Server 2008

• SQL 2008 SMO has the same MailServer Bug as SQL 2005 SMO

  Last December I blogged about a bug in the MailServer object, in that they left out a New() method for creating a MailServer object. The full description of the error and workaround is here and the Connect item I filed on the problem is here .. In browsing Read More... Posted Tuesday, October 16, 2007 12:33 PM by AllenMWhite | 0 Comments Filed under: SMO, SQL Server 2008

• Pay Attention to Cluster Setup

  The weekend of September 29/30 we moved our Data Center from one suburb of Cleveland to another. As you install new servers or replace others it's normal to make certain everything is right before you bring them on line. A data center move is another Read More... Posted Monday, October 08, 2007 11:23 AM by AllenMWhite | 1 Comments Filed under: Database Administration