Unix Technical Forum

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

This is a discussion on time stamp magicaly updated when ever update event occures on a row within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> time stamp magicaly updated when ever update event occures on a row in sql server 2000 i have a ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:43 PM
Daniel
 
Posts: n/a
Default time stamp magicaly updated when ever update event occures on a row

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?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 07:43 PM
MC
 
Posts: n/a
Default Re: time stamp magicaly updated when ever update event occures on a row

This is the way the timestamp is supposed to work. It should get changed
whenever theres a data change in the same row. The engine handles that part.


MC


"Daniel" <softwareengineer98037@yahoo.com> wrote in message
news:OLw76yE$FHA.4028@tk2msftngp13.phx.gbl...
> 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?
>
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:04 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com