My current task in our project is majorly in MSSQL. I wanted to debug a chain of stored procedures and I have just found out that MS has removed debugging tools out of SQL Server 2005 client tools and relied more on visual studio's. I have experienced debugging both from SQL Server 2005 Query Analyzer...

i previously have an experience on debugging stored procedures especially those that involve dynamic sql generation and execution. my experience told me that debugging stored procedure of this type is better with visual studio compared to query analyzer. i encountered a problem with query analyzer before...