hello all.

This is my first posting.

My problem is this: My tempdb is 17 Gig and growing. When SQL restarts it
does not seem to "start over" with a fresh temp db.

I have tried shrinking the database and it successfully goes down about 100
MG (sometimes.)

I have had the hosting company stop the service remove the files and
restart. It doesn't take long to go right back up to 10 Gig+

Any thoughts? Anything I can check on or look for that might be causing
this?

- Bill King -

MS Sql Server LazyDBA home page