Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-27 : 11:11:45
|
Shastry writes "Hi Guis/Gals
It's a big story to complete, so I will give you a clear-cut picture in few words. Actually we are getting
Error 1105 in tempdb
'Cannot allocate space for the object '-16945' in Tempdb because the system segment is full.'
After that we did the following things
1) Expanded Tempdb --------- No Use
2) Separated Tempdb from Master and allocated one big dedicated Device --------- No Use
3) Separated the log and data device for Tempdb on separated disks --------- No Use
4) Again combined the data and log
When I apply the Query ' Select count(*) from sysobjects where name like '#odbc#%' ' in tempdb the ODBC objects ( Most of them are procedures ) are keeps on increasing. So the temporary procedure are not dropping after the transaction.
We are using SQL Sqerver6.5 and Service Pack 4. And our front application (Scopus) doesn’t support Service pack 5a. So it is not possible to apply. Now to clear the tempdb we are restarting the production Server for every 5 hrs
I really thankful to all of you guis if you able to drive me in the right direction
Thanks in Advance
Shastry P " |
|
|
|
|
|
Error 1105 in Tempdb Stating Sytem Segment is Full