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

There is no space in file system and you need to take a back up. What will you do?

842

---

How do I open sybase control center?

955

---

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

1017

---

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

853

---

What is a good example of a transaction in sybase?

1026

---

You need to purge data from audit database. What will you do?

891

---

What is the timestamp datatype in sybase?

953

---

How do I move tempdb off of the master device?

862

---

What is this tds protocol in sybase?

957

---

How to fix a munged log in sybase?

984

---

When are stored procedures compiled in sybase?

849

---

How do I pipe the output of isql to a file in sybase?

890

---

How to connect sybase database from python?

1047

---

What are the main differences between 11.x and 12.x versions of sybase?

843

---

Explain the role of replication server in sybase.

871

---