Ran into this tonight. The other day I updated to Visual Studio 2010 SP1, and my IntelliSense in SQL Server Management Studio (SSMS) 2008 R2 stopped working.
I updated by SQL 2008 R2 install to CU6 and the IntelliSense started working again.
Tag: VS2010
One nice thing released for VS2010 recently is the “Productivity Power Tools”. If you are using VS2010 I would recommend installing it.
Once installed, you can see the options under Tools->Options->Productivity Power Tools
One feature I really like is the “Fix Mixed Tabs” feature.
When you open a code file it will analyze and tell you if need to “Tabify” – convert spaces to tabs, the old developers argument of tabs vs spaces solved. BTW, they should be tabs!
Check out the tools and learn the other features, there are some good things in there to help your code and get around in VS2010.
I love Beyond Compare. Why? First off, their parent company Scooter Software is based in Madison, WI – so that is cool. Second, it is the best damn compare tool I have ever used. I use it for comparing every type of file, folders, folders to FTP, whatever. I love it. Best 30 dollars spent on software. I wish it did more, I could make a wish list.. anyways, to use it to do your source control compares for TFS and SVN? pretty easy.
TFS 2010/Visual Studio 2010
Open VS2010, Tools->Options->Source Control->Visual Studio Team Foundation Server… Click the “Configure User Tools” button
Click Add, and the settings for Compare.. I do .*, and then choose your Beyond Compare locations, and then the args like below
%1 %2 /title1=%6 /title2=%7
TortoiseSVN:
Right click anywhere in Windows Explorer, TortoiseSVN->Settings->External Programs->Diff Viewer
Choose External and then
"C:Program Files (x86)Beyond Compare 3BComp.exe" %base %mine /title1=%bname /title2=%yname /leftreadonly
(remove the x86 if you are on 32 bit, add it for 64 bit)
And.. there you go!
Steve Novoselac's Blog 