Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Createing Triggers for deleting records with Microsoft SQL Server 2000

Status
Not open for further replies.
eamonskelly

eamonskelly

Programmer
Jun 14, 2001
11
GB
How can I create a trigger, so that when I delete a table causes the record to be saved to a new audit-table AND deletes all records associated with that record in another table, passes these records to its own audit-table.
I have got a trigger which works for the main table, but the trigger on the dependent table only puts one of the records into the second audit-table instead of all of them. A cascade delete is occurring in each case, with a one to many relationship between the tables
Thanks
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
515
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
529
pjw001
pjw001
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
304
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
321
Mike Lewis
Mike Lewis
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
962
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top