My co-worker Steve wrote this cool VS.NET add-in that adds SQL intellisense. I've used it at work and it seems to work pretty well. One bug that I'm aware of is the list of columns for a table doesn't display properly for an update statement. All in all a great tool. Check it out.
This hasn't been tested in VS.NET 2000 or 2005 so beware.
SqlAssist
Any of you ever installed a distributed multi-machine system? How did you do it? Did you use an off-the-shelf (OTS) product such as WISE or InstallShield? Well, my company was faced with this decision last year. Here is my story, but I'd like to hear yours. The company that I work for recently released our newest product that is a highly distributed Windows system with tons of C++ COM dlls, DCOM proxies, Registry entries, message queues (MSMQ), Services, .NET Interop, and lots of databases (including ......