ALTER PROCEDURE Doesn't work correctly

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 ?
fnajarAsked:
Who is Participating?
 
Anthony PerkinsCommented:
Do you need help maintaining your open questions?  For the record:

Questions Asked 6
Questions Open 4
Questions Graded: 2
Questions Deleted: 0
Last 10 Grades Given: C B

And here are all your old open questions:
1 06/13/2003 500 Help with a query  Open Microsoft SQL Server
2 06/30/2003 365 I can't run asp's on my IIS Server  Open Internet Information Server
3 09/30/2003 210 Explicit error messages in IIS  Open Internet Information Server
0
 
plqCommented:
Try

exec sp_recompile procname
0
 
LowfatspreadCommented:
whats the actual error message


pot the query
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
arbertCommented:
I'm guessing it's because your SET statements are different between EM and Query analyser (ansi warnings, quoted identifiers, etc.).....
0
 
Anthony PerkinsCommented:
Thank you for the points, but I believe you awarded them in error.  Please see here:
I accepted the wrong answer. Now what?
http://www.experts-exchange.com/help.jsp#hi17
0
 
arbertCommented:
at least you got a C lol
0
 
Anthony PerkinsCommented:
>>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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.