Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 45400 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kk07
If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use
select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.
| Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
Differentiate between db-lib and ct-lib?
How do I tell which tables have identities in sybase?
Explain open server?
What is a natural key in sybase?
You want to delete a table in sybase. How would you do it?
When should I execute an sp_recompile in sybase?
What is the command for quitting from sybase?
How do I configure the burn factor in sybase?
List different types of sybase index.
What is the default table size in sybase?
How would you check the long running transaction?
How do I open sybase control center?
What is trace flags — 5101 and 5102 in sybase?
How configure sybase odbc connection?
Explain locking. List its types.
