I had the same issue with SQl Server 2005. Could not buikd the sp.

Msg 139, Level 15, State 1, Procedure TableInfo, Line 0

Cannot assign a default value to a local variable.

Msg 139, Level 15, State 1, Procedure TableInfo, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Procedure TableInfo, Line 17

Must declare the scalar variable "@DBName".

Msg 137, Level 15, State 2, Procedure TableInfo, Line 20

Must declare the scalar variable "@DBName".

Msg 139, Level 15, State 1, Procedure TableInfo, Line 0

Cannot assign a default value to a local variable.

Msg 139, Level 15, State 1, Procedure TableInfo, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Procedure TableInfo, Line 65

Must declare the scalar variable "@TableSchema".

Msg 102, Level 15, State 1, Procedure TableInfo, Line 86

Incorrect syntax near ','.

Msg 137, Level 15, State 2, Procedure TableInfo, Line 116

Must declare the scalar variable "@TableSchema".

Msg 137, Level 15, State 2, Procedure TableInfo, Line 135

Must declare the scalar variable "@Empty".

Msg 137, Level 15, State 2, Procedure TableInfo, Line 316

Must declare the scalar variable "@TableSchema".

Msg 137, Level 15, State 2, Procedure TableInfo, Line 335

Must declare the scalar variable "@Y".