Share via

SMO FAQ

  • Article

Q: With which SQL Server versions is SMO compatible?
A: SQL Server 2000, and SQL Server 2005.

Q: Is there going to be a redist for SMO?
A: Yes, is a combined redist that contains, SMO, RMO, AMO. NMO, DTS Runtime. This is downloadable from the web: https://www.microsoft.com/downloads/details.aspx?FamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC. File name is SQLServer2005_XMO.msi (and there are 64 bit versions as well).

Q: Will SMO have COM support?
A: We understand the importance of the ability to perform scripting tasks with VBS. However we need to focus on finishing SMO first and are forced to make hard choices, and therefore we decided not to ship COM Friendly Wrappers. We are looking at various options to make this easier for you.

Q: Can SMO work with .NET Frameworks 1.1?
A: No, SMO requires .NET Framework 2.0.

Q: What Visual Studio version is needed to work with SMO?
A: You need Visual Studion 2005 Beta 2 or higher.

Q: Where can I find the SMO samples?
A: You can find the MSI that installs the samples in D:\Program Files\Microsoft SQL Server\90\Tools\Samples. Once installed the samples should appear in D:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\SMO. I posted variuous other samples here.

Q: Will SMO work on 64 bit systems?
A: Yes, SMO is compiled neutral and will JIT to 32 or 64 bits. Note there is one machine dependent SMO component: Microsoft.SqlServer.BatchParser.dll which will be installed in the GAC as both 32 and 64 bits.

 

See also the DMO FAQ.

Comments

  • Anonymous
    April 24, 2007
    Could not load file or assembly 'Microsoft.SqlServer.BatchParser'