Just started using the debugger in Query Analyser in SQL Server 2000.
Is there a way I can edit the code? It's nice to be able to step through the code,
but I don't seem to be able to edit it.
Cheers!
Eric.
use the alter statement
you can use it with Sps, table, view, udf etc
here some example
http://doc.ddart.net/mssql/sql70/aa-az_5.htm
you can also right click on the object in the object browser
and click on script object to new window as and then
clcik on alter
|||You can't edit in debug mode, as Joey says you need to issue an Alter proc command from the editor