Where can i find “Microsoft.SqlServer.BatchParser.

问题:

This question already has answers here:

Closed 7 years ago.

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 Assebly in C#. But I cant find that dll.

If i go to my GAC Folder the Assebly is there:

But the references dialog box in VS2008 won't show it to me.

Where can i find or how can i get that dll?

回答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.