Can We Supress The System Error Messages ?

Hi

Can we supress the System error messages ?

if yes how ?

for ex. In a table I am adding a row which is voilating primary key constarint ..I do not want system message for that ..

Server: Msg 2627, Level 14, State 1, Line 0
Violation of PRIMARY KEY constraint 'PK_b'. Cannot insert duplicate key in object 'b'.
The statement has been terminated.

I can write a user defined message for this purpose but I am not able to supress system message .

The procedure I am using is

CREATE PROCEDURE add_b
@num int,@empno int, @name varchar(6)
AS
INSERT INTO B (num, empno, ds ) values (@num,@empno,@name)
-- Test the error value.
IF @@ERROR <> 0

BEGIN

-- Return 99 to the calling program to indicate failure.

RAISERROR ('Job id 1 expects the default level of 10.', 16, 1)

PRINT "An error occurred loading the new author information"

RETURN(99)

END

ELSE

BEGIN

-- Return 0 to the calling program to indicate success.

PRINT "The new author information has been loaded"

RETURN(0)

END

GO


Sujit