While updating an ASP.NET MVC website running Angular I ran across a $Modal issue and the error was Unknown provider: $modalProvider <- $modal. In order to fix this issues I had to change the $Modal inject to $uiModal, which was due to a naming change in the angular-ui-bootstrap framework.
The framework is located at: https://angular-ui.github.io/bootstrap
I had to make some updates in one of to a clients Azure SQL databases, that required me to drop and recreate a table that had a foreign key relationship. To do this I needed to drop and recreate the FK relationship on a table and I used this script to find all constraints in the the database.
FK_Table = FK.TABLE_NAME,
FK_Column = CU.COLUMN_NAME,
PK_Table = PK.TABLE_NAME,
PK_Column = PT.COLUMN_NAME,
Constraint_Name = C.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK
ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK
ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU
ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2
ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
ON PT.TABLE_NAME = PK.TABLE_NAME
Unfortunately you are not able to run both side by side; so I would suggest you run 2009 in a VM and test your 2010 project in that if you need downward compatibility.
Remember, BizTalk 2010 is the only version of BizTalk compatible with R2 version of the Microsoft Server 2008 and SQL 2008. Setup is still roughly the same.