Originally posted by toby25
Its a text field. So I am not getting the ddl out of it using that SQL. Any other way can retrienve the CREATE PROC DDL?
I do not understand your question. I've just checked my SQL stored procedure and the first line "text" field has
CREATE PROCEDURE ....
I can just copy and paste this text to a command center and recreate the proc.
Are you talking about some other type of the stored procedures, not SQL?