Re: Limit WSS Version History, e.g. to 3 Versions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

If you want to limit your version history to 3 for ALL your lists, you
can also use a trigger in SQL to manage your versions. (IE When a new
version is inserted, and there is 3 for this document, delete the
oldest one).

The sample code for library event handler :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/tsptDocLibEvents_SV01034973.asp

Sven

.

Relevant Pages

  • Re: One more trigger question
    ... They also have a history table which shows all the opt outs and opt ... So I figured a trigger on the ... SQL> create table inactive( ... a customer opts out of some email product. ...
    (comp.databases.oracle.misc)
  • Re: One more trigger question
    ... They also have a history table which shows all the opt outs and opt ...  So I figured a trigger on the ... SQL> create table inactive( ...
    (comp.databases.oracle.misc)
  • Re: An sql dream - thinking in terms of order AND sets at the same time
    ... I guess parallelism isn't important when doing queries. ... why we got away from sequential lists and went to sets. ... History is only history if you are aware of it, ... way as someone practicing sql does not qualify one to represent ...
    (comp.databases.ms-sqlserver)
  • Re: Update trigger
    ... nvltrigger for each column for example. ... SQL> drop trigger emp_upd_trig ... SQL> create table emp ( ... Commit complete. ...
    (comp.databases.oracle.server)
  • Re: Navigation question
    ... This isn't history; well certainly not ancient history - 2003. ... comparing SQL to MUMPS BASIC. ... I favor the SQL query over the ...
    (comp.databases.theory)