From: "Robert Comer" 

>Can you tell I'm a developer and not a
> DBA?   tempdb is a system database (like master).   When you make changes to
> your data, temporary 'inserted' and/or  'deleted' tables are created in
> tempdb that are used a) in case you need to roll back and b) for your
> triggers.   (And maybe the transactions log also uses them, I'm not sure
> but am too lazy to look it up... Can you tell I'm a developer and not a
> DBA?  
> On Wed, 25 Dec 2002 08:01:50 -0500, "Robert Comer"
>  wrote in message :
>
> >So it was just a space problem.  I was wondering just what the problem
> >was...
> >
> >- Bob Comer
> >
> >
> >"Ellen K."  wrote in message
> >news:0fni0vo62q9vq76ldii1elvgi04pm1e5jn{at}4ax.com...
> >> If they hadn't partitioned the drive (or hadn't installed SQL Server on
> >> the C partition) there would have been no problem... the problem was
> >> that the C partition is only 4 GB.   That ain't Microsoft's fault.
> >>
> >> On Sun, 22 Dec 2002 07:41:30 -0500, Mike '/m'
 wrote
in
> >> message :
> >>
> >> >On Sat, 21 Dec 2002 22:20:28 -0800, Ellen K.
> >> > wrote:
> >> >
> >> >>but idiiot #2, who set up SQL Server, obviously doesn't know
> >> >>anything about its internals,
> >> >
> >> >but... but... but... isn't Microsoft back office sooooo easy to
> >> >install and run that you don't need high-powered admins like linux
> >> >does?
> >> >
> >> >isn't one of the reasons for using Microsoft server
software that you
> >> >don't need to kow what you're doing, just install and run?
> >> >
> >> > /m
> >>
> >
>

--- BBBS/NT v4.01 Flag-4