Sybase Question:
Download Questions PDF

How do I check if log truncation is blocked in Sybase?


System 11 and beyond:
select h.spid, convert(varchar(20),, h.starttime
from master..syslogshold h,
sysindexes i
where h.dbid = db_id()
and h.spid != 0
and = 8 /* syslogs */
and in (i.first, i.first+1) /* first page of log = page of oldest xact */

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
The timestamp datatype in Sybase?How do I find the oldest open transaction in Sybase?