How to debug TSQL on SQL Server 2005?

How can I debug TSQL on SQL Server 2005 instance?

开发者_StackOverflow

Thanks.

---

4 Guys From Rolla has a really good tutorial on using Visual Studio to debug SQL Server 2k5 Stored Procedures:

4GuysFromRolla.com: Debugging SQL Server 2005 Stored Procedures in Visual Studio

Unfortunately, as far as I know, Visual Studio is a requirement.

---

Use print statements or log status updates in a table.