Monday, October 1, 2012

Unable to open .sql files in visual studio IDE or Patch update to visual studio causing issues.

Problem 1:- After installation of some add-on's to visual studio, there may be chance for getting below type of errors for ex: After installation of visual studio 2010 service pack 1 one can get these errors.

1) The 'VSTS for Database Professionals Sql Server Data-tier Application' package did not load correctly.

2) The 'RadLangSvc.Package, RadLangSvc.VS, Version=10.0.0.​0, Culture=neutral, PublicKeyToken='package did not load correctly'.

3) The "Language Package" package did not load correctly.

Problem 2:-

unable to open .sql files or sql scripts from visual studio IDE, by cling on .sql file it throws "object reference not found" error.

Solution/Fix:-

Goto visual studio installation media either through disk or hard drive media locate below 3 files and install it.

DACFramework_enu.msi

DACProjectSystemSetup_enu.msi

TSqlLanguageService_enu.msi