Cant see any debug button on toolbar of MS SQL Server 2005

Question

Hi,

Should there be a debug button in the toolbar of MS SQL server 2005? I can't seem to see it anywhere, and really need to step through a SPROC as it's hanging on me! Do I need to install an added-extra or something?

Thanks

Answer 1

T-SQL debugging was reintroduced in SSMS in SQL Server 2008.  To debug in SQL Server 2005, you need to leverage Visual Studio: 

http://msdn.microsoft.com/en-us/library/ms241871(v=VS.80).aspx

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.