MS SQL Print Statement

i would like to enquire about the Print statement. If I do not want to use the Raiseerror to raise an error as its not an error, but want to just print out in a dialog box, how do i do it?

I tried using the Print statement but nothing happened. I am using this inside my trigger, can someone help?

Thank You

Hello my friend,

You can have a table called tblError with one field called ErrorDescription and then instead of using the PRINT statement, do INSERT INTO tblError (ErrorDescription) VALUES ('Part 2 has failed').

Kind regards

Scotty