Full TEMPDB - Help !! 
Author Message
 Full TEMPDB - Help !!
Hi all,
    Our tempdb is always filling (aprox. +60MB/day) because one of the
Access applications in our network is running badly.
    We cannot stop and restart the SQLServer service to empty the tempdb:
we are in a production environment 24 hours day, 7days week. We cannot
stop today one app and tomorrow other to find the ghost.

    How can we detect wich is this application?
    Please, we need a solution.

Thanks.



Mon, 01 Jan 2001 03:00:00 GMT
 Full TEMPDB - Help !!

What tables are in sysobjects, do they contain the letters odbc ?? If so,
make sure all your clients have the stored procedure for prepare statement
in the odbc data source set off.

--
Tony Rogerson
Torver Computer Consultants Ltd.

begin 666 Tony Rogerson.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E)O9V5R<V]N.U1O;GD-"D9.


M3U1%1"U04DE.5$%"3$4Z.SM4;W)V97(],$0],$$R-B!-;V]R;&%N9"!2;V%D
M.TAA<G!E;F1E;CM(97)T9F]R9'-H:7)E.T%,-2 T3$$[16YG;&%N9 T*3$%"
M14P[5T]22SM%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.E1O<G9E<CTP1#TP
M03(V($UO;W)L86YD(%)O860],$0],$%(87)P96YD96XL($AE<G1F;W)D<VAI

M150Z=&]N>7)O9V5R<V]N0&-O;7!U<V5R=F4N8V]M#0I2158Z,3DY.# W,394

`
end



Mon, 01 Jan 2001 03:00:00 GMT
 Full TEMPDB - Help !!
Thank you, Tony
    I think that it is now ok. We have only 3.2MB occupied.
Quote:

>What tables are in sysobjects, do they contain the letters odbc ?? If so,
>make sure all your clients have the stored procedure for prepare statement
>in the odbc data source set off.

>--
>Tony Rogerson
>Torver Computer Consultants Ltd.



Tue, 02 Jan 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Tempdb full but not full

2. Help, Tempdb Transaction log full!

3. 800M tempdb full with two query

4. tempdb full error - daily transaction log dump?

5. msdb,tempdb - full SQLSRV6.5SP4

6. SQL 6.0 - tempdb default segment full error

7. TEMPDB Log Full?

8. tempdb is full urgent

9. DTS to 6.5 database cause tempdb full

10. tempdb log is full

11. Full tempDB


 
Powered by phpBB® Forum Software