I always use the Query Analyser to write/update stored procedures, not the Enterprise Manager.
I also took the habbit of saving my stored procedure in a local file for easy update, but using
sp_helptext procname
will give you your code, so you can copy and paste it into the editing area of the Query Analyser.
HTH!
>Unless I'm missing something, in SQL 7 the editing window for stored procedures is modal, which prohibits things like launching Transact-SQL Help or taking a look at table properties or lots of other useful things. Is there some alternative? I thought I could do edit SQL SPs through Visual InterDev 6 but it only allows me to execute the sp, not edit it.
Sylvain Demers