Answer Posted / vineet pal

1. check error log to find the tempdb full.
2. find out the space free in tempdb usin select lct_admin('logsegment_freepages'dbid)
3. dum tran with truncate only if still full than..
4.dump tran with no_log still full than..
5.find process from syslogshold/sysprocesses. inform user about condition ask for killing if he says yes then
6 kill the preocess
if user says no than alter the tempdb
7 you can also use lct_admin('abort',0,2) to kill all suspended trans.
or last on recomendation restart the server

Explain locking. List its types.

967

---

What happen when we delete the table using trigger?

950

---

How do I set a password to be null?

968

---

How to swap a db device with another?

933

---

Can I partition any table in sybase ?

1053

---

How configure sybase odbc connection?

948

---

How do I bcp null dates in sybase?

997

---

When you change a database option when will it come into effect?

921

---

How can I execute dynamic sql with ase in sybase?

1061

---

List similarities and differences between oracle & sybase.

1021

---

Is sybase free?

891

---

Is sybase relational database?

939

---

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

955

---

How to pad with leading zeros an int or smallint in sybase?

895

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

904

---