mdv3441 (12/8/2010)
I attempted to use this trigger but receive 2 errors and not sure why it is complaining (SQL Server 2005).Msg 2715, Level 16, State 3, Procedure TRG_Profile, Line 1
Column, parameter, or variable #8: Cannot find data type SYSNAME.
Parameter or variable '@CURCOL' has an invalid data type.
Just a thought: Does your database have a case sensitive collation? If so, the datatype may not be recognised if you refer to it using the wrong case.