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

Join in Update query - sql server

Simple join in update query is as follows,

 
 UPDATE T1 SET T1.Name = T2.Name
 FROM TableName T1
 JOIN TableName T2
 ON T1.Id = T2.Id
 WHERE T1.Name IS NOT NULL

Rename project in TFS along with containing folder.

If you rename any project in TFS, it doesn't change the project containing folder inside TFS. Fix for this issue: 1) Goto source control. 2) Click 'Rename' in folder properties. 3) Give new name. 3) open the solution in visual studio. it doesn't load the renamed project. Remove the current project by clicking 'Remove' in project properties. 4) Add the renamed project by clicking 'Add Existing Item'. 4) Check-in the solution.

Rename SQL Server Table Column Name From Team Foundation Server (TFS)

Problem :- Rename the sql server table column name from TFS in visual studio along with changes in stored procedures, functions and other references.

Solution :-

-> Go to that particular table in solution explorer.
-> Right click on table and click on 'View Object in Schema View' and click on table.
-> Expand 'Columns' in Schema View.
-> Right click on column to be renamed.
-> Click on Refactor then Rename..
-> Give new name and click 'Ok'
-> Validate the preview once and complete the process.

Error CS1548: Cryptographic failure while signing assembly

ERROR: Error CS1548: Cryptographic failure while signing assembly

Fix: Goto C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys folder and right click on it, Move onto security tab and give full control to all users.