Integration Basics

Issue: I encountered a strange problem today. When I attempted to open a solution I had developed a few days ago in Visual Studio 2019, it kept crashing. Resolution: Repair Visual Studio. Restart the server or your development box.

 1. Check Active connections Check Active connections by running the below command. If there are any active connections then you need to terminate those connections USE master; SELECT * FROM sys.sysprocesses WHERE dbid = DB_ID('TestDB'); 2. Disconnect users You need to disconnect users. If you run the below statement, it will set the database to single-user mode USE master; ALTER DATABASE TestDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 3. After doing this, try to drop the database by running the below command. DROP DATABASE TestDB;

Issue In some cases when you deploy the changes using CI CD pipeline in BizTalk the changes might not be visible. Root cause CI CD might have skipped the undeploy. Hence you need to manually uninstall by going to the control panel and uninstalling it. Please go ahead and delete the .msi from the back up and the main folder as well