Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 44928 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / prashant
when temp db gets filled
that means there are large number of open process that are
making log of temp db ful in this case we wont even able to
run sp_who
what we will do is :
lct_admin('abort',0,2)
it will kill all open transactions but still log remains
full
now we will alter & extend the database
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
How to check if sybase database is up and running?
Using large raw partitions with replication server on unix in sybase?
When you change a database option when will it come into effect?
How do I bcp null dates in sybase?
Is sybase a database? Explain.
How do the blocker processes exist internally in sybase?
Explain the difference between numeric and decimal data types in sybase.
Explain mirroring?
Explain timestemp datatype in sybase.
What is cis and how can I use it?
What do you mean by asa in sybase?
How do I correct time slice -201?
Differentiate between replication server and sql remote?
What is asa in sybase?
What do you mean by sybase iq?
