>
> Alan, Thankx,,
>
> This is what I wanted,
>
> I want the message to come from a SQL trigger or Stored Proc.
>

Then you need to create and raise an exception. Your application must then
decipher the exception and take whatever action you wish
Alan