I am having issues running this script against a SQL 2005 box (9.0.5000). I keep getting these errors
Msg 2715, Level 16, State 3, Line 280
Column, parameter, or variable #1: Cannot find data type SYSNAME.
Parameter or variable '@idxTableName' has an invalid data type.
Msg 2715, Level 16, State 3, Line 280
Column, parameter, or variable #3: Cannot find data type SYSNAME.
Parameter or variable '@idxName' has an invalid data type.
Msg 2715, Level 16, State 3, Line 280
Column, parameter, or variable #7: Cannot find data type SYSNAME.
Parameter or variable '@IxColumn' has an invalid data type.
Msg 2715, Level 16, State 3, Line 280
Column, parameter, or variable #17: Cannot find data type SYSNAME.
Parameter or variable '@location' has an invalid data type.
SQL Padre
aka Robert M Bishop
"Do or do not, there is no try" -- Yoda