.NET news » Visual Studio

With Microsoft SQL Server 2000 it was possible to debug stored procedures from directly within Query Analyzer (see Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer for more information). With SQL Server 2005, however, this functionality was moved out of SQL Server Management Studio and into the Visual Studio IDE. Using this technique, it is possible to step into your stored procedures, one statement at a time, from within Visual Studio. It is also possible to set breakpoints within your stored procedures' statements and have these breakpoints hit when debugging your application.

All editions of SQL Server 2005 include debugging support (including the Express Edition). However, only the Team Systems and Professional editions of Visual Studio enable stored procedure debugging from within the IDE. In short, if you are using Visual Web Developer or Visual Studio Standard Edition then you cannot step through a stored procedure or enter the stored procedure via application debugging.

In this article we will examine how to debug SQL Server 2005 stored procedures through the Visual Studio IDE. We will look at both stepping into a stored procedure directly from the IDE as well as how to set breakpoints within the stored procedure that are then hit when debugging the application.

Code Review Add-In helps the process of reviewing code and publishing the results as work items to the Team System Server for review by team members

This article describes the basic procedures for creating a Project Template in VS.Net, that can be reused as a custom template for other projects.

Development is often a messy process. Often, you need to organize your code to make it more readable, or restructure it to improve readability. Manually polishing code is both cumbersome and error prone. Fortunately, VS.NET 2005's Refactoring Tool is an awesome new feature that lets you modify your code without affecting its functionality - in other words, it helps you organize your C# code without changing the runtime outcome. This article shows you how to use the Refactoring Tool in Visual Studio.NET 2005 to refactor your C# code with ease.

A Sneaky Peek At Visual Studio 9 (Codenamed Orcas)

Full control over addins loaded into VS2002-2005 - for power users or addin developers

This is a base class to help easily create UITypeEditors. It is used to edit control properties in a DropDown window or a Modal-Form in design mode in the Visual Studio IDE

The next version of Visual Studio, code-named "Orcas", supports new encryption algorithms, big integers, and other worthy enhancements. The CLR team explains.

Shows you how to create a tool window add-in with Visual Studio 2005

Helps developers to build customized design-time extensions for components and controls through smart tag designer panels.