attach
ON DELETE CASCADE
to all your foreign key contraints...
Let EmployeeTable is parent table and EmpID is PK on this.
So when you create other tables to store employee details you may create relationships too... The relationship created with the above statement will do the trick. So when you delete EmpID from parent table, it will be deleted from all children tables.
ALTER TABLE EmployeeSal
ADD CONSTRAINT FK_EmplID
FOREIGN KEY (EmpID)
REFERENCES EmployeeTable (EmpID)
ON DELETE CASCADE;
http://msdn.microsoft.com/en-us/library/aa933119(v=sql.80).aspx
Thanks,
Kuthuparakkal