Answer Posted / ajith prabhakaran

lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.

How do I correct time slice -201?

864

---

List similarities and differences between oracle & sybase.

890

---

How do I tell which tables have identities in sybase?

816

---

Explain procedure cache?

883

---

The secondary truncation point is on. How would you clear the logsegment?

810

---

What is the equivalent of oracle/db2 coalesce function in sybase?

814

---

Can I use a named pipe to bcp/dump data out or in in sybase?

956

---

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

876

---

How do I make isql secure in sybase?

811

---

How do I set ts role in order to run certain dbccs?

733

---

How to start sybase database in windows?

1074

---

What happen when we delete the table using trigger?

847

---

Does sybase support row level locking?

822

---

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

866

---

What is replication server? What is its role in sybase?

878

---