We have a job system running a set of stored procedure. In order to ensure
the stored procedures
are the one we confirmed, we would like to do a calculation of MD5 with
content of a stored
procedure content. And then verify with another database record to make sure
the stored procedure
is correct or not modified. However, I know Sybase 12.5 does not offer any
So I think can I "sp_helptext SP_NAME" to output the content of a stored
procedure and then
calculate the MD5 of the content in another programming language (i.e. .NET
But I worried that the content output from development or UAT sybase (i.e.
may not exactly equal to the production sybase even it is the same stored
Is it possible?
Or any other way to select stored procedure content from internal system
than using "sp_helptext" command?
Any solutions are welcome.
Subject: Checksum of a Stored Procedure
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
Date: 10 May 2010 10:41:54 -0700
X-Trace: forums-1-dub 1273513314 10.22.241.152 (10 May 2010 10:41:54 -0700)
X-Original-Trace: 10 May 2010 10:41:54 -0700, vip152.sybase.com
Xref: forums-1-dub sybase.public.ase.general:29184
Article PK: 78421