return status/error code do to violation of unique key con..

One of my tables has a unique key on the Title column. I have a stored
procedure that inserts a row into the table. I want to return a series of
status/error codes depending on what happened in the code. The successful
insert isn't much of a problem but I need to catch certain
exceptions/errors. One of them is the violation of a unique key. How do I do
this for one and for two, how would you be able to tell what unique key it
was that got violated (in case there is more than 1 on a single table)?

You can always check if the key values exist before insert and report
back those that violate the uniqueness:

SELECT keycol
FROM Target AS T
WHERE EXISTS(SELECT *
FROM Source AS S
WHERE S.keycol = T.keycol);

or:

SELECT keycol FROM Target
INTERSECT
SELECT keycol FROM Source;

--
Plamen Ratchev
http://www.SQLStudio.com