Answer Posted / sanjeev shekhar

use tempdb
go
sp_helpsegment "default"
go

How do I make isql secure in sybase?

811

---

What is the stored procedure to view current lock and processes respectively?

826

---

How to start sybase database in windows?

1074

---

explain engines?

842

---

What does –i option do in sybase tools?

981

---

What is asa in sybase?

859

---

What measures are there to increase the db space?

829

---

What is procedure cache and data cache in sybase?

786

---

How do I find the oldest open transaction in sybase?

845

---

What are the operating systems in which sybase could take its presence?

843

---

How do I take advantage of table partitioning with bcp in sybase?

763

---

List different types of locks in sybase?

908

---

Explain tds (tabular data streams).

844

---

When should I execute an sp_recompile in sybase?

822

---

How does partition assignment relate to transactions in sybase?

782

---