Yes. I need to get back into the habit of posting the changes.txt and
> Just on the tempdb thing, I went to our SQL server today to try and up the
> size of the tempdb database. First went to expand the master device ... and
> found that it's maximum size was a negative number!! And the listed size of
> the device was the same as the maximum size. Of course, this makes it
> slightly hard to expand the master device. The funny thing was that this
> was the same on all the devices except for the EmeraldDev device.
> Maybey the SQL server wants all the devices as contingeuous files on the
> disk !?!?
> If anyone has seen this before, I'd appreciate a hint on how to resolve it.
I have seen it before. Open up isql_w and execute:
as well as any other DBs having problems like this. Typically it will
problem. DBCC has a lot of good options for correcting problems.
> P.S If you do reply, could you email a response directly to me?? I've
> subscribed in digest form (because of the amount of e-mails I get on this
> list), and I get the digest just after work finishes.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com