I was very happy with Intellisense in SQL Management Studio 2008, it worked great. So I was very surprised to have so many issues with it when I installed the 2012 version. First of all, it seems to take forever for it to load/cache database objects that used to be available almost instantly. With the 2012 version I can open a new query window and start typing and I don’t expect any help right away. Sometimes it takes minutes before I get any help. And my databases are not very large or complicated. ......
Do you write stored procedures that might be used by others? And those others may or may not have already started a transaction? And your SP does several things, but if any of them fail, you have to undo them all and return with a code indicating it failed? Well, I have written such code, and it wasn’t working right until I finally figured out how to handle the case when we are already in a transaction, as well as the case where the caller did not start a transaction. When a problem occurred, my ......