Where Can I Find "microsoft.sqlserver.batchparser.dll"?

Possible Duplicate: Can’t find microsoft.sqlserver.batchparser.dll I have Microsoft SQL Server 2008 R2 installed. I want to Include Microsoft.SqlServer.BatchParser.dll as Asse

Solution 1:

The BatchParser is part of SMO. As a simple rule you are never allowed to redistribute a DLL that you did not create yourself, unless explicitly allowed. Redistributable DLLs come in redistributable packages. For SQL Server the SMO redistributable packages come in form of 'feature packs'. For SQL Server 2008 the corresponding feature pack was announced here but the links to the feature pack itself are broken. You can use the Microsoft® SQL Server® 2008 R2 Feature Pack. It contains the SharedManagementObjects.msi which you need to include and distribute with your application to install the required SMO objects on your target computer. Another alternative is to use an open source SQL batch execution library.