How? Currently only one move: Recreate this spdrop proc spname create proc spname in the query analyzer ... Create a stored procedure, it will be line. Why? ANSI_NULLS and ANSI_WARNINGS
After setting the reserved problem, after the stored procedure is created, the ANSI_NULLS and ANSI_WARNINGS options when creating will remain.
Therefore, deleting the stored procedure is over, it is built (built in the query analyzer because the defaults of the query analyzer ANSI_NULLS and ANSI_WARNINGS settings are ON
