We are recompiling stored procedures and some are erroing at execution because they use a different default date format. For example: The current default date format is YYYY-MM-DD, and the SP uses a literal defined as '11/02/2012'. The SP compiles ok but errors when executed. I am assuming the default date format was changed when this SP was compiled. Is the default date format used by the SP kept anywhere where I can retireve it to be sure the re-compiled SP will execute properly?
HELP will show the format of the input variable for the store procedure.
HELP PROCEDURE <dbname>.<spname>;
You can also get the information from:
order by columnid;