Modifying SQL Error Messages

[Dan777]

Does anyone know if there's a way to change the error messages that SQL produces... the "DateTime Field OverFlow" error message just isn't that intuitive to end users, ya know. So is there anyway to change it to something like "Invalid date"?

Thanks,
Dan

 

[tc3596]

There is a way. You can go to the 'master' database and find the table 'sysmessages'. Find your error number and in the description, you can change the text that is displayed. Or you could right click on your server and select 'all tasks', click 'manage sql server messages'. enter the error number and you should be able to change the text here as well.