Modifying a stored procedure in a remote database using inline SQL statement

Question

Post reply

Modifying a stored procedure in a remote database using inline SQL statement

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323741 More actions · Answer 1

just remove the GO just before the ALTER command:

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

changes to

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON

i would simply pass the ALTER procedure command without the SET ANSI stuff ...it's already part of your connection, so no need to add it to the script.

just pass the ALTER command is my recommendation

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!