Using Beyond Compare in Visual Studio Team Foundation Server for Comparing and Merging

This is how you get Beyond Compare working for comparing/merging in vs.net TFS. The default viewer is not as great as beyond compare so it comes very handy when you change to bc.

In Visual Studio do the following:

• Click on Tools menu
• Click on Options menu item
• Expand Source Control tree item
• Select Visual Studio Team Foundation Server tree item
• Click on Configure User Tools... button
• Click the Add... button
• For Extension, type * (for all files)
• For Operation, select Compare
• For Command, browse for C:\Program Files\Beyond Compare 2\BC2.exe
• For Arguments, type /%1 %2
• Click OK to accept

Do the same for Merging.

SQL Server 2008 Annoying warning when saving changes : Saving Changes Not Permitted

When I started working with SQL server 2008 express edition I got a new message that I have not seen in previous versions of SQL Server. The designer does not allow to save table changes like before.

This is the warning message:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
After searching at the options menu I noticed you can disable this warning by unchecking the "Prevent saving changes that require table re-creation".

Since it's a warning message there is a way to remove this simply by unchecking an option in the Tools -> Options -> Designer menu context.

Uncheck the option

"Prevent saving changes that require table re-creation"

This will take care of the issue.

Enjoy!