Was wondering if there is a solution or any tips in counting the number of lines in all the procedures in a database. I have tried the sp_helptext option but this is inaccurate. Am also aware of the syscomments table with the text field which unfortunately has "char(13)" embedded in them....so not very useful....

Any help is appreciated greatly!

In ASE 15.0, this is possible.

sp_helptext sp_help, NULL,NULL,'showsql,linenumbers'

If you are using ASE 12.5, maybe look at the code of ASE 15 sp_helptext and see if it helps?