Probably the database in wich you try to compile is with compatibility level 80 (sql server 2000).
The cross apply work only from compatibility level 90 (sql server 2005).
Try...

Qur7, look 3 post ago, at the end of last reply by Lowell, there are two links.

Hi Lowell, than for tis very usefull script.

i modified some part of code in order to:

Fix Problem when custom data type are defined using name greather...

I modified the "--Get the columns, their definitions and defaults" in order solve the problem of custom data type having name > 16 char, to include 'binary' data type...

Yes i have some custom data type like CREATE TYPE validita_inizio_estesa FROM datetime NOT NULL

CREATE TYPE validita_fine_estesa FROM datetime NULL

.

I also verified that is not coreccted handled the system data...

I find a bug:

Because the tsql statement SPACE(negative_number) return NULL, if is defined a user type with a name bigger than 16 char the sp_GetDDL return NULL

To...