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 |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2000-12-22 : 14:16:25
|
| 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 AdvanceShastry.V |
|
|
|
|
|
Error 1105 in Tempdb Stating System Segment is Ful