i generate scripts of my stored procedures in individual files and store
them into sourcesafe. this way, i can keep track of versions of the stored
procedures. i am now considering using the technique in checking which
stored procedures have changed when i deploy them to the production server.
when i generate stored procedure scripts via enterprise manager, it adds the
following line (or similar):
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
these settings which are in effect when the sp was created are supposed to
be saved with the sp. my problem is that the stored procedures in our
production server have recorded with them different settings. thus, when i
compare the stored procedures between servers, sourcesafe always indicates
that they are different (because the SET QUOTED_IDENTIFIER line are
different) even if the sp text are the same.
is there any way to modify these settings? they don't show up when i edit