Answer Posted / karthik

tempdb space issues
===================

we will try to clear the tran log by using no_log(or)trunket_only(or)normal backup
>dump tran <databasename> to "/path/<file.txt>"
>go
ofter using this command try to exe some sql quray
if it is not working
>dump tran <databasename> with trunket_only
>go
or
>dump tran <databasename> with no_log
>go
the difference between trunket_only and no_log is check point
trunket_only will wait for checkpoing and no_log is execute with out check point
even tho quary is not executed
>select lct_admin(abort,0,2)
>go

You want to delete a table in sybase. How would you do it?

463

---

How can I improve throughput in sybase?

463

---

Explain the role of replication server in sybase.

481

---

How to manually drop a table in sybase?

454

---

Why am I running out of locks on the replicate side in sybase ?

526

---

---

Explain index covering?

489

---

How do I bcp null dates in sybase?

460

---

What do you mean by sybase iq?

486

---

How to divide by zero and nulls in sybase?

508

---

What is cis and how can I use it?

586

---

Explain autosys. Why do you need it.

471

---

Is sybase free?

466

---

What is procedure cache and data cache in sybase?

455

---

Explain the advantages of sybase iq.

509

---

How do I open a sybase database?

451

---