- World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.

  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!

    Send your Resume to 6000 Companies

    Question :
    How do I find the oldest open transaction in Sybase?
    Category Sybase Interview Questions
    Rating (0.2) By 134 users
    Added on 7/1/2011
    Views 410
    Rate it!

    select h.spid,, p.cmd,, h.starttime,
    p.hostname, p.hostprocess, p.program_name
    from master..syslogshold h,
    master..sysprocesses p,
    master..sysusers u
    where h.spid = p.spid
    and p.suid = u.suid
    and h.spid != 0 /* not replication truncation point */

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

    Related Questions
    View Answer
    How do I check if log truncation is blocked in Sybase?
    View Answer
    The timestamp datatype in Sybase?
    View Answer
    How do I remove duplicate rows from a table in Sybase?
    View Answer
    How to implement if-then-else in a select clause in Sybase?
    View Answer
    Fixing a Munged Log in Sybase?
    View Answer
    Hiding your password to isql in Sybase?
    View Answer
    Optimistic versus Pessimistic locking in Sybase?
    View Answer
    How do I force an index to be used in Sybase?
    View Answer
    Why place tempdb and log on low numbered devices?
    View Answer
    Should I run 32 or 64 bit ASE with Solaris?
    View Answer
    What is Intimate Shared Memory or ISM?
    View Answer
    How do I set TS Role in order to run certain DBCCs?
    View Answer
    Differences between clustered and non-clustered in Sybase?
    View Answer
    How do I capture a process s SQL in Sybase?
    View Answer
    What are the catches?
    View Answer
    What is CIS and how can I use it?
    View Answer
    If the master device is full, how do I make the master database bigger?
    View Answer
    What is cmaxpktsz good for in Sybase?
    View Answer
    What is Trace Flags -- 5101 and 5102 in Sybase?
    View Answer
    How to clear a log suspend?
    View Answer

    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here - Best Freshers & Experienced Jobs Website.

    View ALL Sybase Interview Questions

    User Options
    Sponsored Links

    Copyright ©2003-2015, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

    Cache = 0.045898 Seconds