You can use Visual Studio 2003. Create a datsource connection. Then
open server explorer. Find your SP then right-click to edit. You can
debug etc... I personally never use it as I find VS extremely
slooowwww.

With MSSQL 2000, I breakup long procedures by using UDFs that return a
table. My "main" stored procedure consist of calls to the UDFs.