Answer Posted / prashant

when temp db gets filled
that means there are large number of open process that are
making log of temp db ful in this case we wont even able to
run sp_who
what we will do is :
lct_admin('abort',0,2)
it will kill all open transactions but still log remains
full
now we will alter & extend the database

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

926

---

How do I turn off marked suspect on my database in sybase?

927

---

Differentiate between replication server and sql remote?

1039

---

How to check database size in sybase iq?

1039

---

What are the important features of sybase?

1033

---

Can I run any transact-sql command on a partitioned table in sybase?

898

---

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

862

---

What are the vital features of sybase?

907

---

What happen when we delete the table using trigger?

950

---

Explain 'forcing an index' concept.

968

---

What is the use of sp_helprotect in sybase?

1017

---

How do I choose which tables to partition in sybase?

901

---

How do I connect to a sybase database?

1037

---

How would you list objects in sybase?

1004

---

Which version of open client works with which ase in sybase?

981

---