len limitation in routines

I do not get any records for the below, even though I know I have more...

select * from information_schema.routines
where (len(routine_definition)) > 4000

this is SQL 2005. what would you correct in the above query?

Who is Participating?
ralmadaConnect With a Mentor Commented:

If your stored procedure has more than 4000 characters, then the part after the 4000 characters will not appear in INFORMATION_SCHEMA.ROUTINES.

In SS 2005, you can use sys.sql_modules table without worrying about this problem, because the definition column is nvarchar(max).
anushahannaAuthor Commented:
very helpful- thanks ralmada.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.