Altough I increase the size of tempdb this message always occurs.
When the message occurs I dump the transaction log with no_log. But there is no effect.
So I always restart the SQL Services in order to escape this problem.
The message is below:
''Can't allocate space for object 'sysprocedures' in database 'tempdb' because the
'system' segment is full. If you ran out of space in Syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.''

So does anybody know any solution for this problem?How can I solve this problem without
restarting the services?
Thanks....