Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to find when table last altered?

2 posts in General Discussion Last posting was on 2009-12-10 16:41:48.0Z
Nishant Rupani Posted on 2009-12-10 06:32:39.0Z
From: Nishant Rupani <nishant.rupani@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: How to find when table last altered?
Date: Wed, 9 Dec 2009 22:32:39 -0800 (PST)
Organization: http://groups.google.com
Lines: 6
Message-ID: <19380f9d-f612-416a-a24f-a6ab8ee287cb@u8g2000prd.googlegroups.com>
NNTP-Posting-Host: 203.201.251.144
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1260426759 22948 127.0.0.1 (10 Dec 2009 06:32:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 10 Dec 2009 06:32:39 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u8g2000prd.googlegroups.com; posting-host=203.201.251.144; posting-account=y-Y-8QoAAABzR4Wr8eYwc4ZkHK7jRXT_
User-Agent: G2/1.0
X-HTTP-Via: 1.1 tiipx1:8080 (DataReactor/4.1.0p24d2), 1.1 tiipx2:8080 (DataReactor/4.1.0p24d2)
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; MSBrowserIE7; Windows NT 5.1; msie6xpv1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC LM 8),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!u8g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28748
Article PK: 77990

Hi All,

Can someone help me with a way to find out when a table last altered?

Regards,
Nishant


Carl Kayser Posted on 2009-12-10 16:41:48.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <19380f9d-f612-416a-a24f-a6ab8ee287cb@u8g2000prd.googlegroups.com>
Subject: Re: How to find when table last altered?
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2124cc$1@forums-1-dub>
Date: 10 Dec 2009 08:41:48 -0800
X-Trace: forums-1-dub 1260463308 10.22.241.152 (10 Dec 2009 08:41:48 -0800)
X-Original-Trace: 10 Dec 2009 08:41:48 -0800, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28753
Article PK: 77995


"Nishant Rupani" <nishant.rupani@gmail.com> wrote in message
news:19380f9d-f612-416a-a24f-a6ab8ee287cb@u8g2000prd.googlegroups.com...
> Hi All,
>
> Can someone help me with a way to find out when a table last altered?
>
> Regards,
> Nishant

Auditing is the only way that I know of. The information is limited with
respect to the details of the structural change. At least you will know who
and when.