Racosta,

Is there any drawback to creating the database at 100mb as a starter, instead of, say, the "default" 10mb or 20mb? In other words, if HD space was not an...

Thanks Clive. Given today's HD capacities, mapping out 100mb for this thing is really a drop in the bucket. Other than HD space, allotting a large amount for a DB...

Thanks Greg. Actually, I'm trying to determine how big to designate the database... it isn't created yet. If you would, please read my first post again. When documentation says "figure...

Thanks, Steve. If it ever happens that another drive is acquired, I can always reassign the log to the new drive with the ALTER DATABASE command, correct?

Prakash, thanks, for the bit I need that'll work.

Antares, I did download LogExplorer, and it is awesome. Need to convince my boss of the cost, however...

-PD

You know, I figured there would be money involved...

: )

Thanks for the quick reply!

Sounds good. I'll give that a try on Monday. Thanks!

That's what I was hoping. Thanks!

quote:

---

I believe you can restore or attach a SQL 7 database, but you'd have to try. Can't...

Yes, get used books at Amazon. When you search a book, they show who's selling used ones. I've bought 7 books in the last two weeks ALL under $10.00. Last...

... if you finally force yourself to take a vacation after 4.87 years, and upon arriving at the hotel you demand to login to the reservation system's back end CONVINCED...

Also, how about adding an auto-number identity field for each new insert, and pull your data by the criteria as normal, then max(ID), giving you the latest record? Or are...