Re: time stamp magicaly updated when ever update event occures on a row

answered in microsoft.public.sqlserver.programming

Please do not multi-post.

--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:%23ArsAzE$FHA.356@xxxxxxxxxxxxxxxxxxxxxxx
> time stamp magicaly updated when ever update event occures on a row
>
> in sql server 2000 i have a table. when i do any update on the table, a
> field of the effected rows gets a new time stamp, there are no triggers
> on
> the table, nothing special in the DDL of the table, is there any other way
> besides a table specific trigger that this time stamp could be getting
> updated when i do an update on a row? perhaps some other kind of trigger
> that is not specific to a table but specific to a fielde name in any
> table?
>
>


.

Relevant Pages

  • Re: Trigger Question
    ... Pro SQL Server 2000 Database Design - ... I just decided that if my trigger for delete was ... >> SQL Server MVP ... >>> UPDATE OrderDetail ...
    (microsoft.public.sqlserver.programming)
  • Re: Question: Triggers
    ... Shelling out to the OS is not a quick thing to do inside a trigger. ... Tibor Karaszi, SQL Server MVP ... I have a VB.NET application which searches for the existence of these ...
    (microsoft.public.sqlserver.server)
  • Re: trigger changing other table
    ... Columnist, SQL Server Professional ... for example when I decide in trigger that his delete operation should be ... > SQL Server MVP ... > "Artur Z." ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger Security Problem
    ... Post the Trigger Code and the Table definitions. ... Mike Epprecht, Microsoft SQL Server MVP ... > defined as the Windows account I am using, ...
    (microsoft.public.sqlserver.security)
  • Re: Question: Triggers
    ... SQL Server MVP ... Columnist, SQL Server Professional ... Toronto, ON Canada ... I have a VB.NET application which searches for the existence of these "trigger" files. ...
    (microsoft.public.sqlserver.server)