As good as SQL
2005 was (well, still are), one disappointment was that you needed
Visual Studio if you wanted to debug your stored procedures. Seriously,
what was MS thinking when they did that, especially as in SQL 2000,
Query Analyzer had debug capabilities?!!
Anyway, today I am playing around,
errm - doing serious stuff in the RC0 release of SQL Server 2008, and
just by coincidence notice that there is a debug menu entry in the
toolbar(how blind can one be - I must have been looking at that toolbar
quite a few times). So I wrote some T-SQL code, put in a couple of
breakpoint and hit Alt + F5, and lo and behold - my bp’s were hit and I
could step through the code. I then wrote a very basic stored proc,
wrote some code that called the proc, put a bp at the call into the
proc and executed. When the execution stopped at the bp I hit F11 and I
stepped into the proc - WoHoo!!! Call me sad, but stuff like this make
me happy!!
Now, let’s hope that MS will keep this feature in and not pull it at
the last minute - anyone remember the XQuery designer in one of the
very early SQL 2005 beta’s??