0

Is there any way of finding what is the creation date of a stored procedure in Sybase ASE 15? The actual version is 15.0.3.

I know i can find information on this in the sysobjects table, but due to the fact that stored procedures are dropped and re-created anytime they are modified, this shows the last time somebody modified the stored procedure.

Is there any way of finding when was a stored procedure first created?

andreih
  • 423
  • 1
  • 6
  • 19

1 Answers1

0

Not unless you have auditing enabled. When you drop a proc, it's removed from the catalogs. When you recreate it, it's added again with a new object ID and new creation date.

RobV
  • 2,263
  • 1
  • 11
  • 7