Debugging in SQL Server 2008

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??

Advertisements

7 Responses to “Debugging in SQL Server 2008”

  1. Remmrit Bookmarking Says:

    Sql Bookmarks…

    Remmrit.com user has just tagged your post as sql!…

  2. SQL Server 2008 Training Says:

    Hello

    Your website came up in Hello

    Your website came up in my search and I’m taken by what you have composed on this topic. I am presently diversifying my research and thus cannot contribute further; even so, I’ve bookmarked your web site and will be returning to keep up with any future updates. Just Now love it and thanks for granting my remark. Great job and will extend it on to admirers and my web site fans.my search and I’m taken by what you have composed on this topic. I am presently diversifying my research and thus cannot contribute further; even so, I’ve bookmarked your web site and will be returning to keep up with any future updates. Just Now love it and thanks for granting my remark. Great job and will extend it on to admirers and my web site fans.

  3. sdfsd Says:

    asdasd

  4. Ashish Says:

    debugging is very much essential in SQL

  5. site Says:

    Almost all of the responses on this particular webpage dont make sense.

  6. google Says:

    gan izin kopi artikelnya boleh?…thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: