Re: Adding ditigal signatures to records.

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 09/03/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Tue, 3 Sep 2002 13:43:30 -0400

If by that you just want to know if a row was modified you can add a
timestamp (not datetime) column and another to also hold this value. Then
when the row is first created, saved etc you can populate the second column
with the value from the timestamp. Do this only once and you can compare
the 2 values to see if the row was ever changed since the first time. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"Rui Pinto" <ruifgpinto@iol.pt> wrote in message
news:58f901c25366$e6854b20$9be62ecf@tkmsftngxa03...
> Hi,
> I want to know if it's possible to add a digital signature
> to a record in sql 2000, that when the record is changed
> the signature is broken?
>
> If it's not possible then how can i garantee that the
> record is not changed?
>

Relevant Pages

  • Re: Please advise on approach
    ... has direct bearing on the issues and the context is difficult to communicate ... > of the term timestamp - it does not refer to the sql data type in this ... rather to the datetime at which the source produced the data - ... I'm only interested in it differentiating between records ...
    (microsoft.public.sqlserver.server)
  • Re: Convert help needed desperately
    ... overflow error converting expression to data type datetime. ... Is my sql server hosed???? ... > the timestamp data type. ...
    (microsoft.public.sqlserver.programming)
  • Re: trigger updating timestamp
    ... you were scared to use a datetime because it was not accurate....how the ... heck are you going to convert the TIMESTAMP column into something that even ... > datetime wouldn't provide the desired accuracy (like not able to ... > UPDATE TablesLastUpdate ...
    (microsoft.public.sqlserver.programming)
  • Re: Please advise on approach
    ... of the term timestamp - it does not refer to the sql data type in this ... rather to the datetime at which the source produced the data - ... I'm only interested in it differentiating between records ... > insertion order unless that order can be determined by the data itself. ...
    (microsoft.public.sqlserver.server)
  • Re: Please advise on approach
    ... timestamp has no relationship to date or time; ... datetime values are accurate to 3 milliseconds. ... insertion order unless that order can be determined by the data itself. ... pitfall is that reconstruction often implies "re-running" (e.g., ...
    (microsoft.public.sqlserver.server)