Answer / aditya

If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go

If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go

Answer / prabhu

Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb

Answer / sri

use tempdb
go
sp_helpsegment "default"
go

What is the role of replication server in sybase?

0 Answers  

---

Differentiate between clustered and non-clustered index.

0 Answers  

---

What you need to do is issue an ase kill command on the connection then un-suspend the db?

0 Answers  

---

The secondary truncation point is on. How would you clear the logsegment?

0 Answers  

---

How can you change to get the decimal separator as comma instead of the decimal point (.)?

0 Answers  

---

---

What is the depth of triggers?

0 Answers  

---

When should I execute an sp_recompile in sybase?

0 Answers  

---

Explain about the sybase group?

0 Answers  

---

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

0 Answers  

---

How do I create a database in sybase central?

0 Answers  

---

Is sybase a database? Explain.

0 Answers  

---

Differentiate between replication server and sql remote?

0 Answers  

---