create table cust (custid int primary key clustered)
go
create table sale (custid int references cust(custid), i int)
insert cust values (1)
insert sale values (1, 1)
go
--This will cause an error
print 'try the delete'
delete cust where custid = 1
go
drop table sale
drop table cust

OUTPUT:
(1 row(s) affected)

(1 row(s) affected)
try the delete
Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the REFERENCE constraint "FK__sale__custid__40F9A68C". The conflict occurred in database "junk", table "dbo.sale", column 'custid'.
The statement has been terminated.

quote:

---

Originally posted by vijayisonly

You dont need a trigger I think....Just use a DELETE constraint on your table for the foreign key.

"ON DELETE NO ACTION". This would ensure that you cannot delete a row to which there is an existing foreign key.

---

quote:

---

Originally posted by sha_agrawal

Hello Vijayisonly and TG, thanks for reply.
But my front-end is VB6. If I use constraint, it will show SQL Server Constraint violation message and terminate programme. I want to show message also to user.Pls.give me delete trigger code.

---