1

Hi All Sybase Experts And Coders,

I have a strange requirement to find out when my Tables in database was last truncated? Is there any way to find out using any of the systemtables in sybase.

If Answer to above is No, then any solution to implement this? Since we have triggeres in DML statement level not sure will those come in handy in case of Truncate to log this execution time.

I'm using Sybase 15.7 version.

Any help is Highly Appreciated.

Cheers, Prashant

Prashant
  • 11
  • 3

1 Answers1

0

You have to implement database auditing in ASE.

Here is also an example of querying the audit data.

Adam Leszczyński
  • 1,079
  • 7
  • 13
  • Thanks for the info and links. However this would require higher privileges for me. Is there any way using system tables available in Sybase to deduce this information? – Prashant May 29 '18 at 13:19
  • No there is no other way. You can also however configure replication with Replication Server and create some kind of handler for truncate on the target site. But this would be more sophisticated and complex approach. – Adam Leszczyński May 30 '18 at 20:17