use tempdb go sp_helpsegment "default" go

How do you troubleshoot if your tempdb gets filled

Question Posted / sri

Answer Posted / sri

use tempdb
go
sp_helpsegment "default"
go

Is This Answer Correct ?

11 Yes

25 No

Please Help Members By Posting Answers For Below Questions

Explanation about replication server software?

500

List the types of locking?

525

Does sybase support row level locking?

447

Explain locking. List its types.

505

What do you mean by exception log in replication?

475

How would you lock a table in sybase? What text command will you use for it?

489

How do I move tempdb off of the master device?

467

Is sybase a database? Explain.

481

What is rollback trigger in a trigger?

536

What sybase central?

472

What is cmaxpktsz good for in sybase?

474

How to manually drop a table in sybase?

454

How do I open sybase control center?

501

How do you check database space? What measures are there to increase the db space?

513

Does table partitioning require user-defined segments in sybase?

416