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

How do I open a sybase database?

449

---

How can set the multipal database ?

2456

---

Is sybase free?

464

---

What is this tds protocol in sybase?

479

---

What will cause the size of a stored procedure to grow in sybase?

418

---

---

Explain table partitioning in sybase.

527

---

What is sybase infomaker?

500

---

List similarities and differences between oracle & sybase.

526

---

Can two tasks be assigned to the same partition in sybase?

446

---

What measures are there to increase the db space?

483

---

How do I force an index to be used in sybase?

421

---

How to restore sybase database in sap?

494

---

What is cis and how can I use it?

582

---

List different types of locks in sybase?

513

---

What are the different types of (all page) locks in sybase?

441

---