Debugging Stored Procedures

Matt,

I’ve always used SQL Server Management Studio to debug. I reverse engineer the stored procedure and replace variables where needed. If there is an error it will show you on the messages tab in red when you run it.  What problem are you having?

Naomi

One for the geeks out there ...

What's the best way to debug stored procedures in SQL Server 2005? I heard that it can be done in Visual Studio 2005, but I haven't quite been able to get it to work. I'm not sure if that's because I've got it set up the wrong way, but I couldn't insert any breakpoints or access any sort of Step Into function, which made it difficult.

What do other people use?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Matt,

I’ve always used SQL Server Management Studio to debug. I reverse engineer the stored procedure and replace variables where needed. If there is an error it will show you on the messages tab in red when you run it.  What problem are you having?

Naomi

One for the geeks out there ...

What's the best way to debug stored procedures in SQL Server 2005? I heard that it can be done in Visual Studio 2005, but I haven't quite been able to get it to work. I'm not sure if that's because I've got it set up the wrong way, but I couldn't insert any breakpoints or access any sort of Step Into function, which made it difficult.

What do other people use?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!