If you're using constraints, you cannot change the message the SQL Server generates. If you want to have SQL Server return a customized error message, you'll have to enforce the rule with a trigger and return an error message with the RAISERROR command.

If you want to continue using constraints, you'll have to intercept the error message and translate it into something more user-friendly.

-Mike