How to debug stored procedures in Visual Studio 2008

It's very easy to debug the stored procedures in Visual Studio 2008. All you have to do is connect to the database from VS 2008 and run a stored procedure. Here are the steps:

1. Go to Server Explorer and open a data connection.





2. Once you add a database connection, open the stored procedure.




3. Step in to the stored procedure.





4. Pass the inputs.






5. Start debugging !





Happy Coding,

Madhu

Visual Studio 2008 & .Net 3.5 Released

Microsoft released the newer version of Visual Studio(previously Orcas) and .Net 3.5. The VS looks cool; it has a lot of new features like intellisense for JavaScript, new CSS editor, Multi-targeting for previous frameworks etc. There is a trial version(90 days) available on Microsoft's website. Give it a shot.

Trial version:
http://msdn2.microsoft.com/en-us/vstudio/products/aa700831.aspx

some more info on Scottgu's blog:
http://weblogs.asp.net/scottgu/archive/2007/11/19/visual-studio-2008-and-net-3-5-released.aspx

Happy Coding,

Madhu