How to fix the “could not load file or assembly microsoft.sqlserver.batchparser” error

The Problem: Every time you attempt to run Microsoft’s excellent Database Publishing Wizard Utility you get the following error after you enter your login information could not load file or assembly microsoft.sqlserver.batchparser

The Cause: This problem can be taken literally – Microsoft.SqlServer.Batchparser is not installed on your computer.

The Solution: Go To this link on the Microsoft site and download the Microsoft SQL Server 2005 Management Objects Collection. Then install the MSI

That’s it!

For those of you who are not familiar with the tool, the Database Publishing Wizard is a free tool Microsoft made which allows you to generate sql scripts of existing databases, which speeds up moving them around on third party hosting better than any other method.

photo credit: gnizr

 

This post originally appeared on the Stronico blog – with the absorption of Stronico into Digital Tool Factory this post has been moved to the Digital Tool Factory blog

 

Written By Steve French

 

This entry was posted on Thursday, September 30th, 2010 at 5:42 pmand is filed under How To Fix . You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

 

 

Latest Tweets & Social