July 26, 2004 at 11:45 pm
I have program in visual basic and my database is SQL 2000 and its work in network.
I have two table one called bill to record geberal information of invoice and another tablke called BillData to record items of invoice.
The problem i face now that with time there is some records from begining deleted from tables without any notice and no one can update or delete any records after 24 Hours.
I but triggers for Bill table to monitor any Insert,Update,Delete nad its save in table the problem happen again two records deletes but its not showing that in the table of the trigger.
any one have idea aabout that
July 27, 2004 at 8:56 am
When you say no one can update or delete, did you take away permissions just as a check?
Test your trigger. Create a dummy record into the table and then delete it. Does the info show up in the trigger table?
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply