I want to write a trigger to avoid appending duplicate records in a table. How can I know the new value of the columns inside the trigger? (SQL 2000)

CREATE TRIGGER [trg_append] ON [dbo].[tbl_ec_master_findings]
FOR INSERT
AS
if (select count(*)
from tbl_ec_master_findings
where tbl_ec_master_findings.str_facility =@str_facility) <> 0
begin
print "already exists."
rollback transaction
end