Answer Posted / kk07

If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use

select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.

How do I find the oldest open transaction in sybase?

845

---

What is the stored procedure to view current lock and processes respectively?

827

---

Explain relationship between jdbc and sybase.

844

---

How do I take advantage of table partitioning with bcp in sybase?

763

---

Explain bind cache?

881

---

What is the difference between natural join and equi join?

856

---

How would you replicate col = col + 1 in sybase?

986

---

When should I execute an sp_recompile in sybase?

822

---

What is server replication?

905

---

How can I improve throughput in sybase?

847

---

Can you create your own sps for system wise?

860

---

You need to purge data from audit database. What will you do?

847

---

How would you configure burn factor in sybase?

884

---

How do you view log files in sybase?

897

---

How to fix a munged log in sybase?

903

---