June 21, 2006 at 2:43 pm
We have dev and stage machines. Both use sa to create procedures.
To deploy stored procs across all the servers we use OSQL.
After altering a procedure i test it in QA to make sure it returns the same results. However on stage there were no results (all tables exist on both machines)
Both machines have the same permissions as SA.
Can someone tell me what's going on?
It only worked when i created a new procedure and dropped the existing.
And renamed the new back to the existing
I have to do this manually for all the servers.
June 22, 2006 at 8:32 am
Check OSQL user for valid permission on prod.
------------
Prakash Sawant
http://psawant.blogspot.com
June 22, 2006 at 12:22 pm
I figured it out.
it was these clauses missing from the procedure
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER YOUR STORED PROCEDURE
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply