• 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