Friday, May 23, 2008

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

No comments: