It has been some time since I've done any heavy (read: thousands of lines of) T-SQL in Management Studio, but thanks to a client's stubborn policies regarding data access layers I'm going to be writing a bible's worth of stored procedures. In the interest of not going completely insane trying to solve "Error near this half of the script" problems, I was wondering if anyone had a Management Studio plugin handy that offered some level of Intellisense support. I've poked around online a bit but haven't come up with anything definitive.
I tried that one for a while, and it didn't seem to work very well (this was a couple years ago though). Many times it wouldn't pop up the intellisense list at all, and other times it wouldn't have the correct items in the list. Restarting would normally fix it, but it got old fast.
What version of SQL Studio are you using, out of curiosity?
Posts
But hey, I guess if you end up keeping it, you could always charge your client. M i rite? :winky:
I tried that one for a while, and it didn't seem to work very well (this was a couple years ago though). Many times it wouldn't pop up the intellisense list at all, and other times it wouldn't have the correct items in the list. Restarting would normally fix it, but it got old fast.
What version of SQL Studio are you using, out of curiosity?