Sometimes we want to recreate an existing error class, for example, taking one from production into a new UAT environment. It is not really possible to do this but we can work out the modified error codes in the user defined error class and then manually recreate the class.  Run the SQL, in the RSSD, below and pipe the output into 2 files

First file

==========

select ds_errorid, action=v.name

from rs_erroractions e, rs_classes c, rs_tvalues v

where e.errorclassid=c.classid

and e.action=v.value

and v.type=’ERR’

and c.classname=’rs_sqlserver_error_class’

order by 1

go

Second File

===========

select ds_errorid, action=v.name

from rs_erroractions e, rs_classes c, rs_tvalues v

where e.errorclassid=c.classid

and e.action=v.value

and v.type=’ERR’

and c.classname=’ASEallowdupsErrorClass’

order by 1

go

Now do a ‘diff’ against these files and any different codes will be displayed.  To find out what the codes are, in RSSD

rs_helperror 2601, ‘v’

You can then build your error class using the knowledge gained above.