I'm not sure what that means. Should i create a data device just for tempdb?
> -----Original Message-----
> From: Dale E. Reed Jr. [SMTP:firstname.lastname@example.org]
> Sent: Monday, May 24, 1999 12:11 PM
> To: email@example.com
> Subject: Re: [Emerald] Need Help Fast - SQL Error Message
> Brad Teague wrote:
> > I am getting this error message:
> > "Error 1101: [SQL Server] Unable to allocate new page for database
> > There are no more pages available on valid allocation pages. Space can
> > created by dropping objects, extending the database, or dumping the log
> > no_log."
> > I have received a somewhat similar message before when the emerald log
> > out of space (i think) and I had to increase its size so that I could
> > truncate it. I did that this time and it didn't work. I am still
> > this same message no matter what I have tried. The Emerald log shows
> that it
> > is empty ..shows that its full size is available.
> > I'm just not sure what this message means and I need to figure it out
> > Any help would be greatly appreciated.
> tempdb is a different database than Emerald. You need to expand it,
> similar to how you expanded your Emerald DB.
> Dale E. Reed Jr. Emerald and RadiusNT
> IEA Software, Inc. www.iea-software.com