Visual Studio Data Compare Not working

Sometime you can be able to view Data compare menu in you visual studio toolbar. Once you go there and select one option nothing will happen. To get it into work you have to run following command in your VS command prompt.

devenv /setup

Comments

Not able to install SSMS 18.4, Set is stuck showing "Loading Packages. Please wait"

I could able to fix this with following steps: 1) Removed "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18" folder 2) Deleted registry key "HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio" 3) Installed SSMS

The transaction is in doubt

Sometimes you may get this error when you use transaction scope . The transaction is in doubt I also got this error recently and able to find the reason for it. That is because of the some of the readers had not properly disposed. Actually in this case you can use Using keyword to overcome this. Exception : System.Transactions.TransactionInDoubtException was unhandled by user code Message="The transaction is in doubt." Solution : using (reader) { }

MySQL Stored Procedure Error

In our project we had many many stored procedures and many parameters passes to those sps. But in only one sp it gives error message something like this; "Incorrect number of arguments for PROCEDURE sproc_t_l_Contract_Select_BySearchCriteria; expected 3, got 2” Work long time on this sp but coudnt find it. So i tried to write it again from the begining. In this time it was work perfectly.This problem occurs because of the space between data type and its length. Ex. pName varchar(50) - working pName varchar (50) - Not working But it does not mention syntax error or something.So this error message make us vulnerable.

Blogging 4 Life

Search This Blog