if you are having trouble getting intellisense like I did with VS 2008 here are the steps that you can take download the bdcmetadata.xsd from following url and copy the file to “c:\program files\Microsoft Visual Studio 9\xml\schemas” directory (assuming...

In SQL Server management studio when you try to save changes after altering table you might experience an error message that says something like “saving changes not permitted. The changes you have made require following tables to be dropped and re-created...