We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

ALTER PROCEDURE Doesn't work correctly

fnajar
fnajar asked
on
Medium Priority
343 Views
Last Modified: 2008-03-06
Hi.
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 ?
Comment
Watch Question

plq

Commented:
Try

exec sp_recompile procname
CERTIFIED EXPERT
Top Expert 2011

Commented:
whats the actual error message


pot the query
Top Expert 2004

Commented:
I'm guessing it's because your SET statements are different between EM and Query analyser (ansi warnings, quoted identifiers, etc.).....
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Top Expert 2012

Commented:
Thank you for the points, but I believe you awarded them in error.  Please see here:
I accepted the wrong answer. Now what?
https://www.experts-exchange.com/help.jsp#hi17
Top Expert 2004

Commented:
at least you got a C lol
CERTIFIED EXPERT
Top Expert 2012

Commented:
>>at least you got a C lol<<
I am not complaining: That was 1000 points :)

But seriously, some people just don't get it.  I mean who is going to help ot someone with this record:

Questions Asked 6
Questions Open 3
Questions Graded: 3
Questions Deleted: 0
Last 10 Grades Given: C C B
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.