Browse by Tags

Debugging stored procedures on SQL Server 2005

Published 09-26-2007 12:41 PM | jokiz

My current task in our project is majorly in MSSQL. I wanted to debug a chain of stored procedures and I have just found out that MS has removed debugging tools out of SQL Server 2005 client tools and relied more on visual studio's. I have experienced...

Filed under: SQL, visual studio, debugging

Stored Procedure Debugging

Published 11-15-2006 9:42 AM | jokiz

i previously have an experience on debugging stored procedures especially those that involve dynamic sql generation and execution. my experience told me that debugging stored procedure of this type is better with visual studio compared to query analyzer...

Filed under: SQL, visual studio, debugging, stored procedures

Enhanced debugging with debugging attributes

Published 06-07-2006 9:01 PM | jokiz

i have read before that .NET 2.0 enhances debugging with the new debugging attributes. most useful one that i have seen is the ability to filter out all the members of a class instance as displayed in debugging windows (watch, locals, etc.) using DebuggerBrowsable...

Filed under: .NET, debugging

Visual Studio Tip #4 - Debugging expressions by highlighting

Published 04-28-2005 6:30 PM | jokiz

When you just want to watch for the result of a particular operation, like (this.Right - this.Left)/2 you don't need to copy and paste it in the Immediate Window or launch QuickWatch with the expression selected. You just have to select the said expression...

Filed under: .NET, tips, visual studio, debugging

MissingMethodException during a form load at designtime

Published 03-17-2005 7:26 PM | jokiz

Some control properties where dropped. Forms still have them in InitializeComponent. Form is loaded at designtime with an attached debugger instance (devenv.exe). CodeDomSerializer class tries to deserialize the said property set. A MissingMethodException...

Filed under: .NET, visual studio, designer, windows forms, debugging

Visual Studio Tip #1 - Break into Debugger when Exception is thrown

Published 02-24-2005 6:22 PM | jokiz

The Visual Studio Debugger is one of the developer’s closest friend but befriending VS takes a lot of effort especially if you are just new in using it. I myself took time before I can fully exploit the VS debugging features and I want to share them to...

Filed under: .NET, tips, visual studio, exceptions, debugging