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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 version control

Author  Topic 

99miles
Starting Member

7 Posts

Posted - 2002-04-27 : 19:31:21
I'm trying to figure out how to save the changes to a fields, so i can later revert to any set of changes made in the past. I thought that's what transactions were for, but I guess they are only good for queries that occurred within the current session, right?

I know I could simply save a whole new copy of the data in a new table row, but that could start to take up a lot of space.

I thought that what I want to do could be done...but I'm starting be be unsure now.
Anyone have a an answer?
Thanks a lot-
mac


VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-04-27 : 19:46:40
I responded in the 'General SQL Server' forum!

--
HTH,
Vyas
Check out my SQL Server site @
http://vyaskn.tripod.com
Go to Top of Page
   

- Advertisement -