Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-01-27 : 19:11:25
|
| Well,First, I want to thank RobVolk for his help with Triggers.I was just thinking about deleted records in the database.Of course you can capture the event, including the record identifier, but is their a way to capture then entire data set that is being deleted that is economical? I am sure there is but I have no idea how to query the Deleted table to get all records in a way that does not require me to write individual triggers that are table specific. I have a sizable number of tables, and its going to get alot bigger, is there any solution that is viable? Can I just select * the data and put it in a varchar or text field?Thanks for your time.Software Composer |
|
|
|
|
|
Grabbing sql of a Delete Statement