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

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

981

---

What is the use of 'with check' option in views?

958

---

How do I configure identities in sybase?

918

---

Explain 'forcing an index' concept.

968

---

How do I make isql secure in sybase?

926

---

Explain mirroring?

907

---

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

1097

---

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

998

---

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

955

---

Differentiate between db-lib and ct-lib?

1022

---

Explain the advantages of sybase iq.

947

---

What do you mean by asa in sybase?

1038

---

Is sybase a database? Explain.

1012

---

What is raid and sybase?

1016

---

What is server replication?

1050

---