I have moved a database form a old legacy MSSQL server 2000 (SQL Server 8) to SQL Server 11 and im receiving some errors in several triggers.
They are formed like this.
RAISERROR 20001 @msg
RAISERROR 44444 'Field ''comp_v1'' cannot contain a null value.'
so after some reading i see that this is a known change, but i cant find any good known solutions.
At first i thought to just replace them to something like this
RAISERROR ('Field ''comp_v1'' cannot contain a null value.',16,-1)
The issue here is, well i have no real idea on what effect this has, and if there is any good straightforward conversion from the old line to a new line.
Im assuming that there is a reason for the codes 44444 and 20001 etc.