Debugger returns in Management Studio
Finally we get a T-SQL debugger back into SQL Server Management tools. Evidently it was announced at the Launch Event in LA that Microsoft has decided to put the T-SQL Debugger into SQL Server Management Studio. This is something that was in Query Analyzer for SQL 2000 but we haven’t had it for 2005 up until now. See here for more information. However here’s the pertinent excerpt:
<excerpt>
So what are the surprise features?
#1: we’ve rewritten the activity monitor to be far more useful and performant (funny word) than ever before. This was work Ken Henderson started before he passed away. One of Ken’s good friends and a dev on the team, Bart Duncan, took over the work to complete it in Ken’s honor. I showed this at launch.
#2: object search: yes, we’re bringing back object search. In Object Explorer Details we’ve added a search bar that will search for database objects. It’s a simple yet powerful search. Unfortunately I wasn’t able to demo it at launch.
Drumroll please…
#3: the debugger: we’ve brought back the T-SQL debugger in Management Studio. This is huge and incredibly valuable. And yes, I demoed it at the launch event.
BTW: #3 had the highest number of votes in Connect and #2 was close behind. We did these because customers told us they are important feature to them. While Connect does have its flaws, it also has its good things. Keep the feedback coming!
</excerpt>