ALTER PROCEDURE Doesn't work correctly
Posted on 2004-03-29
I have a stored procedure that include a dinamyc query.
If i modify that stored procedure from the "enterprise manager", runs well.
But, if i modify that stored procedure from the "query analizer" using the "alter procedure" statement,
when i run the stored procedure, i get an error message.
This always happen to me when i do this with stored procedures that have dinamyc querys.
What is happen ? What can i do ?